Auto update Form

[JK]

In my database I have a suppliers form with a button that opens a city form.
What I want to happen is that when I enter a new city into the form it
automatically refresheses the city combo box on the supplier form without
having to close and re-open the supplier form.
Is this possible and if so how is this done. (I have this issue with most of
my other forms so If I can get this rectified it would alleviate alot of
frustration with the system users.
Thank-you in advance

 

[Arvin Meyer MVP]

You would use the NotInList event to open a form to add a city. Here's some
generic code which will open a form to add the city to that table:

http://www.datastrat.com/Code/NotInListCode.txt

There should be other code in the help files.

 

[Mr. B]

JK,

While there is nothing wrong with using the method that you describe, you
may want to invistigate the "OnNotInList" event of your combo box that
displays your cities. This works to allow users to type in the City name and
if that name is not in the list, it can be added automatically and the list
updated.

Check the help files, or search here for how to implement this built in
functionality in Access.

Here is link that provides code to do this.
http://www.mvps.org/access/forms/frm0015.htm