Access Combo Box Refresh

[EarlCPhillips]

I program a volunteer scheduling application for the local food bank. When a
new volunteer arrives, someone adds them to the database. If they are from a
new city or a new zip within the city (checked by drop-down boxes for city or
zip code), we add the new city/state/zip/county to the underlying table by
using a pop-up newcity form. After the city or zip has been added to the
underlying table, the new city or zip does not show up in the combo boxes but
does show up in the underlying table. It shows up in the combo boxes if we
quit the application and start it up again. How do I "refresh" the
underlying table for the combo boxes without shutting down the application?
What event should this be in?

Any help will be appreciated.

EarlCPhillips
Ex-Mainframer Learning Access To Help
Feed The Hungry More Efficiently
Harvesters Community Food Network
Kansas City, MO 64129

 

[Marshall Barton]

I program a volunteer scheduling application for the local food bank. When a
new volunteer arrives, someone adds them to the database. If they are from a
new city or a new zip within the city (checked by drop-down boxes for city or
zip code), we add the new city/state/zip/county to the underlying table by
using a pop-up newcity form. After the city or zip has been added to the
underlying table, the new city or zip does not show up in the combo boxes but
does show up in the underlying table. It shows up in the combo boxes if we
quit the application and start it up again. How do I "refresh" the
underlying table for the combo boxes without shutting down the application?
What event should this be in?

The popup forms must be opened in dialog mode to pause the
code until the form is closed. Then the next line after the
OpenForm line can use:
Me.thecombobox.Requery