=?Utf-8?B?bWVzc2FnZSBkaXNwbGF5?= <message display
@discussions.microsoft.com> wrote in
I need a pop box to notify me when a value = a value when a time
(9:00) time() = a vaule a message appears
Right, well, what you'll have to do is create a timer event. It's an
event of the form object. If you know when the form opens what the time
will be, then you just can just set the timer value to when it will come
up, and bring your pop-up immediately in the timer event code. If you
won't know, or if the value might change and it's in a table somewhere
so you need a recordset then your going to have to decide how acurate
you need to be.
It looks like you only need a minute, so every 45 sec. should do fine.
Remember to clean up your objects.
Good luck,
-mwalts
