can't select from combo on continuous subform

[Anne]

I have a query called QryInventory. When I look at the query, I can add data.
I have a main form FrmInventoryNew, which solely serves the purpost of
selecting a Greenhouse.

The subform is a continuous form based on QryInventory.
I have a combo on that form to select the bench based on a greenhouseID.

I based the combo on a query where the criteria for GhseID
=[Forms]![FrmInventoryNew]![GhseID].
Looking at the subform, new data entry is not allowed. I never changed any
of the settings of the subform but I can't figure out why I can't enter new
data?
Thanks for any help?

 

[Anne]

I can see why I can't enter data. I just looked at the query for the combo
and it shows that there can't be any data entry.
How else do I select the GHBenchID for a specific greenhouse?

 

[pietlinden]

I can see why I can't enter data. I just looked at the query for the combo
and it shows that there can't be any data entry.
How else do I select the GHBenchID for a specific greenhouse?

could you post the SQL (and maybe the structure of the relevant tables
if necessary)? Sounds like you're using an inner join instead of
including the filter in the Where clause of your query.

 

[Anne]

Thanks, you pointed me to the problem. After some trial and error I got it
right.
In the query Inventory, I used the GhseID from the Bench table instead of
the one on inventory table.