Pop up message on a form

[VWilson39]

It has been a while since I have been on this forum. I would like to know if there is a way to have a message pop up on a form when a date is about to expire. I have a database that deals with goals for youth. The goals have an estimate expire date (never pass a year) Our problem is we have 500 plus youth. The goals expired but need to be updated. I know how to create a pop up message using the Msgbox function but I don't know how to connect the two. If that makes sense. Thanks for any help you might provide.

 

[WayneRyan]

V,

You can use the form's OnCurrent event to do this.

If Me.ExpireDate <= Date Then
   MsgBox("Expired.")
End If

You could also look at making a report that will show all expired, or soon
to be expired records.

Wayne

 

[VWilson39]

Thank! That work to a point. But you are right a query is better.