|
Subject:
|
Combo Box Problem
|
|
Posted By:
|
munrrob
|
Post Date:
|
9/21/2006 9:27:47 AM
|
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.
|
|
Reply By:
|
SerranoG
|
Reply Date:
|
9/21/2006 10:35:47 AM
|
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
|
|
