Access event procedure (1 Viewer)

[allen-bartram]

Can any one help PLEASE. I'm trying to write an access database
where one of the fields is COMPLETE_DATE. The field contains the details of when a job is to be completed by.

If this date is exceeded, I want the database to give me an on screen message or popup message (either) to tell me that the job hasn't been completed on time. I have spent hours on the net and reading books, but can't find the answer.

Any help would be appreciated, before I pull out my last remaining strands of hair. Thanks in advance. Allen

 

[Rich]

Private Sub Form_Current()
If Date > Me.DteCompl Then
MsgBox "Wake up Bozo this job is overdue for completion !"
End If
End Sub
Where DteCompl is Complete_Date renamed on the property sheet

 

[Pat Hartman]

Each time the database is opened, you'll need to run a query that looks for Complete_date <= Date()