troubleshooting Question

How do I capture the value of the AdterUpdate event to prevent Debug Error

Avatar of juricta
jurictaFlag for United States of America asked on
Microsoft AccessVBA
3 Comments1 Solution17 ViewsLast Modified:
On this  program I have been working on I want to catch an error before it starts. I think I can do this if I can find out if a FIELD has been updated/changed.
The cashier scans in an item but the customer decides they don’t want the item or the cashier screwed up so they want to delete the item. If you RIGHT CLICK the record you can choose to delete the record.  However,IF you try to delete the record BEFORE you have changed the quantity an error occurs and you have to debug.  I am trying to prevent this error.
Here is the how process currently works:
1.Cashier scans the item and realizes it’s a mistake
2.Cashier MUST change the quantity field BEFORE deleting the item
3.Cashier Right Click record now and chooses to delete and it works OK.
               a.If cashier forgets to change the quantity BEFORE deleting the error occurs

How can I check to see if the quantity has been changed in the QUANTITY field when the cashier RIGHT CLICKs the record to delete
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros