I have a combo box that selects two fields from a table, ID and Description, binding on ID, displaing only Description. There is an AfterUpdate event that limits the selection in a second combo box based on the users selection.
This works very well.
When I go back into a saved record the data is displayed correctly in these combo boxes. However, when I close the form containing the record I am asked for the value in the first combo box. This only happens when I go into the form and do not change the value in the first combo box. If I change the selected record then the form closes down fine and the changes are saved. This one is driving me crazy, any help would be appreciated.

What do you mean by "I am asked"? Do you mean an input box appears? Could it be a query is being run that is a parameter query on the form's ON CLOSE event?


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division