Field Update

[LaughingBull]

I have and attendance Form



When I have a new location I click Enter New Location and that form open and I enter the new location close that form.
When I select the location the new record I just entered does not show up in the selection list. I have to close the attendance form and reopen it for the new location to show up on the list of locations.

Is there a way for the drop down location list to be automatically updated as soon as I enter a new location into the Location Table and I do not have to close the form and reopen it?

[pbaldy]

You could probably use the NotInList event of the combo rather than a special button (search here on "notinlist"). Keeping it like it is, add code to the close event of the location form:

Forms!ThisFormName.LocationComboName.Requery

[June7]

Alternative:

Open the location form with acDialog parameter, this will suspend code execution from the calling form until location form closes.
Then the next line of code would be:
Me.comboboxname.Requery

However, the NotInList event is a better approach to adding the new location record 'on-the-fly' during data entry.

[LaughingBull]

I used the on Close event and it works great
Thank you

[pbaldy]

Happy to help! If that form can be opened independently, you may want to test that "ThisFormName" is open first, or you'll get an error if it isn't. Search here on IsLoaded for that test.