Blank screen using parameter queries

S

stevens

I have wondered this for about a year but never got around to asking the
question. Using a parameter query to populate a form. If the user enters
valid data, but the data is not in the database, Access returns an empty
screen. Is there a way to give the user a message that the data was not
found and cancel the inquiry before Access displays the empty screen? I
have several forms in production use that do this and would like to know how
to handle it better than the empty screen trick. Thanks
Steve
 
P

Pieter Wijnen

check the forms' me.recordsetclone.bof in the form_open event & set cancel
accordingly

HTH
Pieter
 
Top