I'm sure this should be an easy statement, but I can't seem to get it to work. I need to make sure information is put into 4 fields or I want it to give a message and quit. If the criteria is there, open the form. Here's what I tried. It doesn't work.
If IsNull(cboInciMonth) And IsNull(txtInciYear) And IsNull(cboRptMonth) And IsNull(txtRptYear) Then MsgBox "You must enter a criteria"
Exit Sub
Else
DoCmd.OpenForm "frmMappsSearchResults"