SimonPGreen
IS-IT--Management
Hi all,
I have a form with a combo box that uses a select query as a row source. I have created a button to allow a user to maintain the data in the table the combo box uses so that a record can be added on the fly. The problem is however that it appears the combo is populated on form load and when a new record is added the combo box does not list the new entry.
What is the best mechanism to get the combo box to update so that the new record can be selected without having to close and reopen the main form?
Appreciate any help.
Regards,
Simon
I have a form with a combo box that uses a select query as a row source. I have created a button to allow a user to maintain the data in the table the combo box uses so that a record can be added on the fly. The problem is however that it appears the combo is populated on form load and when a new record is added the combo box does not list the new entry.
What is the best mechanism to get the combo box to update so that the new record can be selected without having to close and reopen the main form?
Appreciate any help.
Regards,
Simon
