I have a combo box on my form that is based off a parameter query.
In order to add a record to the form, I have to check if there are records or not in the combo box (so I know if i should use the
DoCmd.GoToRecord , , acNewRec
So, the parameter query the combo box is based off is called(FunderCheck), and i am trying to open it with a recordset in vba, but when i try to run this, my error is: "Too few parameters. Expected 2". The form is open and the parameters are there, so i don't know quite what else to do. Here is the code (this is Access XP):
Dim rst as Recordset
Dim db As Database
Set db = CurrentDb
Set rst = db.OpenRecordset("FunderCheck",
As an alternative, I'm thinking i may be able to have another query that counts how many (if any) records are counted in the FunderCheck query, i just don't know how to do it in VBA.