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
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