View Full Version : Blank form showing if criteria not found.


geno
09-27-2001, 06:31 AM
I have a form which runs on a parameter query,if the criteria is not met the form opens up blank. I would like if the criteria is not met a msgbox displays telling the user that the record does not exist. If the criteria is met the form opens with that record showing. Thanks

Rich
09-27-2001, 06:36 AM
In the open event If RecorsetClone.RecordCount=0 Then
MsgBox "NoRecords"
DoCmd.Close
End If

geno
09-27-2001, 08:33 AM
Thanks works great...