Requery on subform not working - Error 2118

[AlexMidd]

I am trying to get a subform to requery after having enetred data into a pop-up form. I need certain data to be entered only when 1 category out of a number of categories has been chosen. The pop-up appears to prompt users to enter the data required. I want the form to close and then requery the subform. It won't let me do it and I get the following error. Any ideas?

Run-time error '2118':

You must save the current field before you run the Requery action.
Have fun! )

Alex Middleton

 

[scking]

The error is relatively descriptive. Apparently you have entered data in a field on the subform and when you try to requery you would lose that value so it won't let you. Either save the value (.save) or remove the value (.undo) before doing the requery.

Steve King Growth follows a healthy professional curiosity