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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top