auto-populating fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pegasus - 09 Apr 2005 23:49 GMT

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.

Reply to this Message

Ken Snell [MVP] - 09 Apr 2005 23:58 GMT

Comments inline...

Signature

Ken Snell
<MS ACCESS MVP>

>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.

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.

Use the NotInList event (with LimitToList property set to Yes). See The
ACCESS Web:
http://www.mvps.org/access/forms/frm0015.htm

Reply to this Message