accessingaccess
Registered User.
- Local time
- Today, 05:12
- Joined
- Mar 2, 2019
- Messages
- 11
Hello! I am working on a database for my store to keep track of store credit for customers. Currently, I have a form where we can add customer contact info, and there is a subform that displays credit history and totals. We are also using this subform to add and subtract customer credit. I would like to have a message box appear when someone assigns a large amount of credit to ensure that they meant to assign that much, as we are rarely assigning more than say ~$50. Is there a way when someone saves the form after adding more than $50 in credit on the subform that I can have a message box pop up asking that they confirm the credit amount? Currently I have it appear whenever someone saves the file, but I'd like to only appear when a large amount is added so that people don't get used to just clicking "OK" after every time they save. Maybe there is a better way than using the subform? Any advice is appreciated! Thank you. -A