Unanswered: why does it prompt for an existing field value?
I have a form based on table. In it I have a combo box that looks up values from another table. A second combo box uses the values from the first combo in order to select its contents....so far so good and everything works fine when I add some VBA to requery the 2nd combo results after the first is updated.
However, when I close the form a Box pops up with the jolly title of:
Enter Parameter Value - asking for the contents of the first combo box.
(which I used as the criteria of the sql to select the contents of the 2nd combo box)
Now I've added these form elements via the wizards, and for the sql field criteria I used the expression builder - so surely this means that access can't have misplaced the form value.....er right?
Any ideas as to what's causing this? It's driving me nuts!
In this case it might be worth you sending a cut-down & zipped version of your db up.
Create a new database and then export the relevant forms/queries/tables into the new database. Zip the file and upload it here