Automatic Pop up Reminders

[steve99jones]

Hi

I'm fairly new to Access and databases in general but I have built a great database which I am really pleased with, but I want to be able to have a pop-up reminder which is activated when a date in one of the form fields is reached.

First of all is this technically possible?

If it is could somebody give me an indication of how to go about doing it because I have no idea!

If it is not possible, is there any other way around it?

Thanks in advance for your assistance and the simpler you can keep any advice the better!!

Many thanks

Steve

 

[ghudson]

Use the forms OnCurrent event. Something like this will get you started.

If [YourDateField] > "mm/dd/yyyy" Then
     MsgBox "Date in the YourDateField has exceeded the limit."
End If

If the date in that field can be altered then you should also use the AfterUpdate event for that date field with the same code above.