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_Addr ess. 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_Addr ess 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_Addr ess 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_Addr ess table, automatically.

The TAX_NAME field in the Total_Site_Addr ess 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]

Re: Populating fields.

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" <JASON.BUCK@CO. COLUMBIA.WI.US> wrote in message
news:f0a23f5e.0 404271316.33c2f 4e9@posting.goo gle.com...[color=blue]
> 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_Addr ess. 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_Addr ess 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_Addr ess 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_Addr ess table, automatically.
>
> The TAX_NAME field in the Total_Site_Addr ess 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.[/color]