Matching products

[fludan]

HI

I have created a form with 2 subforms for the shipping department, 1 is the order detail and the other one is ship order.
The order detail is from a query called order subform and ship order is from a table called ship order.

When I ship an order, I enter the order No., when I press enter it shows the order detail in the order detail subfrom then I take a product and enter the product ID via scanner (all my products are barcoded) in the ship order subform.

The problem i have is that we have some employees that scan the wrong items in and subsequently send the wrong orders out. I want to know if it's possible to have a message box or a beep signaling an error if the barcoded item does not match the order detail form. Also when they press print to print out the shipping label and if an error is make where they only scanned in 1 product and forgot 2 others that a message box or beep or something appears to make them aware of their error.

Is this possible, and if so can someone please give me an example of how to do it.

Thanks
Frank

 

[FoxProProgrammer]

If the ProductID that you scan in is called ProductScanID and the ProductID that you want to compare it against is called ProductID...

If ProductID <> ProductScanID Then
MsgBox &quot;You scanned the wrong item.&quot;, 16
End If

Is this what you are looking for? dz
dzaccess@yahoo.com

 

[fludan]

Yes something like this, is this right

Private Sub PRODUCT_ID_Enter()

if Forms![SHIP ORDER]![SHIP ORDER SUB] ![PRODUCT SCAN ID] <> Forms![SHIP ORDER]![ORDER DETAILS] ![PRODUCT ID]
MsgBox &quot;You scanned the wrong item.&quot;, 16
End If

Thanks
Frank