Hi everyone
I've been working on a user form which some staff at work have asked for. I have attached form below to save time explaining what it looks like. When you open the form, you will be able to see what it is I'm trying to achieve. The form named "Remind me" has pre-set events in place, along with DTPicker's for staff to forist select the time of the event, and a second to select how much to before the event takes place they want the reminder. What I want to happen is when the time on the top of the form matches the time they have advised the event takes place, the form named "lunch" then appears.
I understand the - application.ontime now + timeserial("00:00:00"). I have tried using this in many ways however I am still unable to get the Lunch form to appear when the times match.
Apologies if any part doesn't make sense
Any help would be greatly appreciated
Thanks
Test.xls
Bookmarks