I have a form with two subforms; one in the header and another in the detail area of the main form.
The header is used for data entry and contains a bound combobox which allows other controls inside the header to be populated specific previous record information found in the detail form.
Problem:
When something is selected from the combobox and the user clicks off the header form, I receive the following message:
The Microsoft Access database engine cannot find a record in the table 'tblTrucks' with key matching field(s). TruckNumberLookup.
I imagine I need a way to reset this combobox to default if something outside the header form is selected. What is the proper way to resolve this problem?
The header is used for data entry and contains a bound combobox which allows other controls inside the header to be populated specific previous record information found in the detail form.
Problem:
When something is selected from the combobox and the user clicks off the header form, I receive the following message:
The Microsoft Access database engine cannot find a record in the table 'tblTrucks' with key matching field(s). TruckNumberLookup.
I imagine I need a way to reset this combobox to default if something outside the header form is selected. What is the proper way to resolve this problem?