Populating fields.

[Jason]

I have a form that is used for entering and editing site address
information. The data in the form is from one table, named
Total_Site_Address. There are fields in this table (and controls on
the form) for entering in a new site address or choosing an existing
site address. There are two fields that address the existing site
addresses, one named ADDRESS, the other named TAX_NAME (contains
municipality info). The ADDRESS field is setup as a lookup and it
pulls the site address data from a query. This query, named
SiteAddress-Existing, pulls data from two linked tables. In the
SiteAddress-Existing query, there are two fields named SITE_ADD and
TAX_NAME. The Lookup values for the ADDRESS field are from the
SITE_ADD field in the SiteAddress-Existing query.

I would like to be able to automatically update the TAX_NAME field in
the Total_Site_Address table based on the ADDRESS field. In the form,
there is a control that allows the user to choose a site address from
from a combo box. When this address is chosen, I would like the
TAX_NAME field in the Total_Site_Address table (and the control in the
form) to automatically update with the municipality that the chosen
address exists in.

An example of this is if a user chooses from the combo box "123 Jones
Road", with a corresponding Tax_Name in the SiteAddress-Existing query
of "Town of Johnson", I would want the "Town of Johnson" to be stored
in the TAX_NAME field in the Total_Site_Address table, automatically.

The TAX_NAME field in the Total_Site_Address table is a Text field,
and the control on the form which displays the TAX_NAME is just for
display, not data entry.

Thanks for any advice.

[Robert]

It's not clear what you're driving at. You want to create a combo box which
looks up a town based on a street address? So the user selects "1600
Pennsylvania N.W." (the address of the White House) and it returns
"Washington, D.C."? (Not so unusual.)

Robert

P.S. Post table layouts

"Jason" <JA********@CO.COLUMBIA.WI.US> wrote in message
news:f0**************************@posting.google.c om...

I have a form that is used for entering and editing site address
information. The data in the form is from one table, named
Total_Site_Address. There are fields in this table (and controls on
the form) for entering in a new site address or choosing an existing
site address. There are two fields that address the existing site
addresses, one named ADDRESS, the other named TAX_NAME (contains
municipality info). The ADDRESS field is setup as a lookup and it
pulls the site address data from a query. This query, named
SiteAddress-Existing, pulls data from two linked tables. In the
SiteAddress-Existing query, there are two fields named SITE_ADD and
TAX_NAME. The Lookup values for the ADDRESS field are from the
SITE_ADD field in the SiteAddress-Existing query.

I would like to be able to automatically update the TAX_NAME field in
the Total_Site_Address table based on the ADDRESS field. In the form,
there is a control that allows the user to choose a site address from
from a combo box. When this address is chosen, I would like the
TAX_NAME field in the Total_Site_Address table (and the control in the
form) to automatically update with the municipality that the chosen
address exists in.

An example of this is if a user chooses from the combo box "123 Jones
Road", with a corresponding Tax_Name in the SiteAddress-Existing query
of "Town of Johnson", I would want the "Town of Johnson" to be stored
in the TAX_NAME field in the Total_Site_Address table, automatically.

The TAX_NAME field in the Total_Site_Address table is a Text field,
and the control on the form which displays the TAX_NAME is just for
display, not data entry.

Thanks for any advice.