Ok, so to give a little background, we have supplies that come in to our supply room. Once they are received, they need to be QA inspected as well. The query selects items that have been received, but not yet QA'd. I'd like to be able to open a form for the QA inspection of only those items selected by the query. The information such as item name, manufacturer, supplier, etc. is stored in a table and the itemID is the link between the items table, and receipt table, and the QA release table. But there is other information on the release form which needs to be saved after the items have been inspected. So I want the query to select items that haven't been inspected, open the release form showing only those items, enter the inspection information, and save it to the release table. And here's the blah, blah, blah:
WHERE (((tblReceipt.Reconciled)=False) AND ((tblReceipt.ReceiptConditionSat)=True) AND ((tblReceipt.QSUNotified)=True));
Thanks for your time and effort!
John D