The section of my database in question allows users to request permission to overbook an appointment.
They aren't allowed to book (let alone overbook) any appointments on a day when the clinic is closed.
When they enter the form to request permission, the first thing they do is enter the date for the overbooking.
I've got a routine that will compare the date they've entered into my text box OBDate to the table with the clinic closed dates. It pops up a message box to tell them the clinic is closed and no appointments are allowed.
The problem I'm having is figuring out what event is the best one to use to run that routine.
I've tried BeforeUpdate, AfterUpdate, Exit, LostFocus and none of them act reliably.
Behavioral quirk: Most of my users use the TAB key to move from box to box but some insist on using their cursor. Don't know if that affects the answer but it might.
Any help would be greatly appreciated. After all these years, I still don't really understand events.
Thanks!
Kitty
Start Free Trial
