Blank screen using parameter queries

  • Thread starter Thread starter stevens
  • Start date Start date
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
 
check the forms' me.recordsetclone.bof in the form_open event & set cancel
accordingly

HTH
Pieter
 
Back
Top