darrelhawes
Technical User
I'm working on a data-entry form which has several combo boxes linked to tables. In most cases, I have restricted data entry to the lists in the combo boxes (pulled of course from the underlying tables). I have set up command buttons next to some of the combo boxes in order to add new records. When the button is depressed, another form pops up which the data entry person can use to review the existing records in that table and/or add a new one.
For the purposes of discussion, I'll call the main form "Book" with a table linked to the combo box "Author".
Here's my problem: after adding a record and closing the "Author" form, the new record doesn't show up immediately on the combo box of the "Book" data entry form. If I close the "Book" form and re-open, the new record does appear. Of course that defeats the purpose of including the command buttons.
In summary, how can I force the new record to appear in the "Author" combo box within the "Book" form without closing and re-opening the "Book" data entry form?
Darrel
For the purposes of discussion, I'll call the main form "Book" with a table linked to the combo box "Author".
Here's my problem: after adding a record and closing the "Author" form, the new record doesn't show up immediately on the combo box of the "Book" data entry form. If I close the "Book" form and re-open, the new record does appear. Of course that defeats the purpose of including the command buttons.
In summary, how can I force the new record to appear in the "Author" combo box within the "Book" form without closing and re-opening the "Book" data entry form?
Darrel