How do I lookup a value from another table and insert in my form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to have Access look at a soils table and based on the soil
type I select in a combo box, go to that table and select the limitations for
urban development specific to that soil type...and then place it in the main
report.
 
Examine the Orders form in the Northwind database example. They lookup the
price based on the product.
 
I want to be able to have Access look at a soils table and based on the soil
type I select in a combo box, go to that table and select the limitations for
urban development specific to that soil type...and then place it in the main
report.
Click to expand...

Create a Query joining the Soils table to the table upon which you're
basing the Report, and choose the desired field or fields from the
soils table.

John W. Vinson[MVP]
 
Back
Top