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

[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.

 

[[MVP] S.Clark]

Examine the Orders form in the Northwind database example. They lookup the
price based on the product.

 

[John Vinson]

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.

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]