Cascading Combo Query

[Rpettis31]

I have a combobox that will pull an order number cbrderNumber then I have
a cascading box cbrderLines that lists all the lines on the order. I am
not sure how I can I pull the item number for the OrderNumber and the
OrderLine.
This information is all on the same table tblDMRItemMaster.

 

[Jeanette Cunningham]

Hi,
the general explanation is that you use the value from the first combo to
apply a filter to the query that is the row source of the second combo.
Whatever value user chooses in the first value, forms the criteria for that
field in the query that is the row source for the second combo.
The second combo doesn't show all the records returned by its row source, it
only shows those records that match the value selected in the first combo.


Jeanette Cunningham -- Melbourne Victoria Australia