Message box in a form

[Cillies]

Hi all,

I am building a database in Access for a video store. I'm at the stage where I want a message box to appear if a video has not been returned before the specified return date.

I am using the [Return Date] and a [Returned] Yes/no check box to register whether a video has not been returned. I have used conditional formatting, but I would also like a message box to appear as soon as the account is open stating that a video has not been returned.

I tried using the below code, but this only works if I click the [Returned] yes/No check box.

Private Sub Form_Current()
If [Return Date] <= Date And [Returned] = False Then
MsgBox "The customer has not returned a video"
Cancel = False
End If
End Sub

Hope someone can help

 

[LonnieJohnson]

It may be that your check box is not actually false. It could be in it's third state which is grayed out. Try stating "If Not True".

Try...

Private Sub Form_Current()
If [Return Date] <= Date And [Returned] <> True Then
    MsgBox "The customer has not returned a video"
    Cancel = False
End If
End Sub

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[Crowley16]

just as a note...

the greyed out state is actually = null

--------------------
Procrastinate Now!