hello all,
i have a question regarding the structure of some queries i am creating.
in this database (picture of form attached below) i have a query (call it qry1) that feeds a Work Order to a combo box which populates some fields. that part works great.
from this work order, i have a list box that should be populated with the Dlot Numbers belonging to the work order. (A Work Order can have anywhere from 1 to 14 Dlot Numbers). i have created a separate query (call it qry2) for the list box, one that only has the fields Work Order and Dicing lot.
How can i filter qr2 so that it shows only the Dlots belonging to the Work Order in the cbo box referenced above?
i have tried various things as my criteria but none seemed to work.
=[forms]![frm name]![cbo name]