Auto update Form

  • Thread starter Thread starter JK
  • Start date Start date
J

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
 
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
 
Back
Top