Combo Box Problem
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.