Auto Access

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

I am fairly new to access, so pardon if this sounds like
a newbie question...I am making a list of my clients in
access to import into a POS (Point of Sale) system and
would like to know if there is a way to have a drop down
menu for zip codes/States/Cities within those respective
fields, and also if it is possible to have those fields
pre-filled with the information. Please post a step by
step answer on how to do it (newbie) and thanks in
advance.
 
This may work for you, Tiffany ...

The following example is for a combo box from which a user will select a zip
code and, based on that selection, city and state will be auto-filled. You
can, of course, edit it to work with your application.

1. Make the control on your form for zip code a combo box.

2. Set the properties of your combo box as follows:

Row Source: Select ZipCode, City, State from tblZipCodes Order by ZipCode
Column Count: 3
Bound Column: 1
Control Source: name of zipcode field in the table which is the
RecordSource of your form

3. In the After Update event for your combo box, insert the following code,
which will update City and State fields on your form:

Me!City = Me!MyComboBox.Column(1)
Me!State = Me!MyComboBox.Column(2)

hth,
 
Back
Top