URGENT - cascade combo box problems in subform

[Guest]

Desparate for help.

I'm using Northwind as a template for a Purchase Order database. In the
Orders Form / Subform I want to have a Suppliers combo box which filters the
Categories combo box which then limits the Products combo box. I have seen
examples, but have being going round and round and getting nowhere (possibly
due to my lack of expertise in Access).

I am needing to finish this project urgently and ask for any help that could
see me thru to the bitter end.

Thanks in anticipation

 

[Rick Brandt]

Desparate for help.

I'm using Northwind as a template for a Purchase Order database. In
the Orders Form / Subform I want to have a Suppliers combo box which
filters the Categories combo box which then limits the Products combo
box. I have seen examples, but have being going round and round and
getting nowhere (possibly due to my lack of expertise in Access).

I am needing to finish this project urgently and ask for any help
that could see me thru to the bitter end.

Thanks in anticipation

With your form/subform open in design view go into the query builder for the
RowSource on the Part Number ComboBox. In the Criteria row right-click and
choose the builder option.

From there you should be able to navigate to the ComboBox for suppliers via...

Forms
Loaded Forms
Main Form Name
Subform Name
Supplier ComboBox Name

In the AfterUpdate event for Suppliers you need to issue a Requery on the part
number ComboBox.

Me.PartNumber.Requery