Like parameter

[John Williams]

Hi
I am using the "like" parameter like"*"&[Enter Invoice]&"*". If I put an invalid or non exsistant invoice in I go to a blank form. Is there a way of giving a message instead of the blank form

 

[ajetrumpet]

you can issue a message box on the open event of the form based on frm control

 

[SOS]

You can check the form's recordsource to see if there are any records and cancel the opening if you want:

Private Sub Form_Open(Cancel As Integer)
  Dim rs As DAO.Recordset
    Set rs = Me.RecordsetClone
       If rs.RecordCount = 0 Then
          MsgBox "There Are No Records", vbInformation
          Cancel = True
       End If
End Sub

(Untested Air Code)