DCount with Msgbox
Posted on 2013-09-17
I am trying to have a form prompt the operator that they have completed the order. I did search and I did find the code I sort of need, but I cannot alter it so that it works.
They currently scan the item numbers to an order with a barcode scanner. Once the total # of items is scanned, I want a message box to pop up to alert them that they are done.
"load_complete" is a query that checks the total scanned items vs. the total qty ordered. Once the scan_qty and order_qty are = to each other, that query gets populated. My assumption was that as soon as that occurs, after the last item is scanned, the after update would see that and would pop up the message box. Or is this something that should be done
Private Sub item_no_AfterUpdate()
If DCount("*", "load_complete") > 0 Then
MsgBox "Order Complete"