Does a query have to run as soon as checkbox on form is checked?
Windows Vista 
Access 2007
I’m using an access 2010 to manage items received. I run a query based on an “Order Number” which returns one or more records. The results appear on a form. This form has info for each record and also has a “Receive” checkbox (yes/no field) that I check when I receive an item. After I check the “Receive” box for the appropriate record, I click a button on the same form to create a receiving report.
Everything works fine. However, in order to avoid a mistake by receiving an item twice, I’d like to change the query criteria from only searching for records matching the “Order Number” to searching for records that match “Order Number” and where the “Receive” is no, or false. This way something that has already been received will not appear in the query results.
I can get the query to work fine like this, but my problem is that once I check the “receive” box to create the receiving report, the query picks up the change in the record and removes it from the list of results since the “Receive” has changed to yes, or true.
Is there a way to make the query run after I print the report instead of right after I check the "Receive" box? Any help would be greatly appreciated. Thanks for your time.
Reply With Quote
Originally Posted by ssanfu
