auto-populating fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000 and I'm trying to have the City and State fields
auto-populate from the Zip Code Combo box linked to a table with prefilled
data. I would also like to know how to have the table update with new Zip
Codes when I enter a new one.
 
Comments inline...
--

Ken Snell
<MS ACCESS MVP>

Pegasus said:
I am using Access 2000 and I'm trying to have the City and State fields
auto-populate from the Zip Code Combo box linked to a table with prefilled
data.
Click to expand...
Have your combo box Row Source query contain the City and State fields. See
The ACCESS Web:
http://www.mvps.org/access/forms/frm0058.htm

I would also like to know how to have the table update with new Zip
Codes when I enter a new one.
Click to expand...
Use the NotInList event (with LimitToList property set to Yes). See The
ACCESS Web:
http://www.mvps.org/access/forms/frm0015.htm
 
Back
Top