Lookup Columns

  • Thread starter Thread starter Mike Mueller
  • Start date Start date
M

Mike Mueller

Here is what I have:
Access 97
Tables : Orders & ZipCodes
Orders table is used for ordering products. Amongst the
fields, there is a field called zip which refers to the
ZipCodes table. The zipcodes table also contains the tax
rate for that particular zip code. What I would like to do
on my form is to select the zip code and automatically pull
the tax rate for later use on the form.

I know this has been answered before, I just couldn't find
the subject

TIA

Mike
 
Mike Mueller said:
Here is what I have:
Access 97
Tables : Orders & ZipCodes
Orders table is used for ordering products. Amongst the
fields, there is a field called zip which refers to the
ZipCodes table. The zipcodes table also contains the tax
rate for that particular zip code. What I would like to do
on my form is to select the zip code and automatically pull
the tax rate for later use on the form.

I know this has been answered before, I just couldn't find
the subject

TIA

Mike
Click to expand...


If the user selects a zip code from a combo box, be sure that the tax rate
is included in the columns for the combo. The following expression assumes
that you have two columns in your combo, the first column being the zipcode.
The 2nd column is the tax rate. This expression will successfully refer to
the tax rate of the selected zipcode.

=[ComboBoxName].column (1)

HTH- Betsy
 
Back
Top