Cascading Combo Query

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have a combobox that will pull an order number cbo.OrderNumber then I have
a cascading box cbo.OrderLines 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.
 
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
 
Back
Top