Simple Msg Box

[Derrick T. Davidson]

I have a form with one txt box [PickPDate] and one button [ViewReport], when i click the button if there is no date entered I want to show a msg box (preferably customized with my title, and OK. Message says "Please enter a date" and OK cancels the event, otherwise it opens the report. Please forgive me if this is to basic a question, I have searced archive threads and most are way ahead of me in Access.

[June7]

In VBA, like:

If IsNull(Me.PickPDate) Then
MsgBox "Please enter a date", vbOKOnly
Else
DoCmd.OpenReport "report name"
End If

[Derrick T. Davidson]

Fantastic works great, I have an additional question if that is ok, how about if I have two txt boxes[PickPDate] and [PickName] and both need to be completed to achieve the actions you gave me above. Do I enter two "If" Statements or is there a better way??

[June7]

You could do two If statements or one:

If IsNull(Me.PickPDate) Or IsNull(Me.PickName) Then