S
Stan
I have a form with two combo lookup boxes. One box selects
from a list of 95 different properties and the Second box
selects from 1200 different tenants.
What I would like to happen is when the user selects the
property in the first combo lookup box, they then use the
second combo lookup box to select the tenants that are
listed for that property only. I have setup the two combo
boxes using a query, but when I use the second box it
pulls all tenants in the tenant table.
I have two tables
table 1 list all property info
table 2 has all tenant info
The linking field is the project description which is
posted in both tables.
I cuurently have a query that uses both table to the
project description and tenant names. I have also tried
using the indivual tables as the source table without
success.
As I see it, my problem is that once I get the property I
have no way to link to the selected project in the form.
from a list of 95 different properties and the Second box
selects from 1200 different tenants.
What I would like to happen is when the user selects the
property in the first combo lookup box, they then use the
second combo lookup box to select the tenants that are
listed for that property only. I have setup the two combo
boxes using a query, but when I use the second box it
pulls all tenants in the tenant table.
I have two tables
table 1 list all property info
table 2 has all tenant info
The linking field is the project description which is
posted in both tables.
I cuurently have a query that uses both table to the
project description and tenant names. I have also tried
using the indivual tables as the source table without
success.
As I see it, my problem is that once I get the property I
have no way to link to the selected project in the form.