I'm designing a booking system and have created a macro to clear the form so it's ready for the next data entry. The problem is the booking needs to be printed and added to the database from the form first. What i'm wondering is how would i get a pop up message which reminds the user of this where it is possible for an "OK" and a "cancel" style option. At the moment all that happens is the message pops-up asking if the booking has been saved and added and the user can only click ok which will then clear the form regardless of whether it's been added or printed.
Copy of what i'm using at the moment is below:
MsgBox "Have You Printed and added this booking before clearing?", vbInformation
Thanx for any help, BEX
Copy of what i'm using at the moment is below:
MsgBox "Have You Printed and added this booking before clearing?", vbInformation
Thanx for any help, BEX