Hello,
I have a search form. The search form has a combobox and a subform. When a user selects from the combobox (they select a supplier code), the subform will display the the searched results.
In the subform, users are allow to add new records. When the user add a new record, the supplier code (that was selected from the combobox) will automatically input the same code into the new record.
How can I stop this from happening? the user can add a new record but the supplier code does not have to be the same as the combobox selection.
any help or suggestion is very much appreciated!
I have a search form. The search form has a combobox and a subform. When a user selects from the combobox (they select a supplier code), the subform will display the the searched results.
In the subform, users are allow to add new records. When the user add a new record, the supplier code (that was selected from the combobox) will automatically input the same code into the new record.
How can I stop this from happening? the user can add a new record but the supplier code does not have to be the same as the combobox selection.
any help or suggestion is very much appreciated!