Parameter Queries & Reports

[Nixx1401]

I created a report using a parameter query. When the parameters are entered the report generates correctly and fine.



The parameters are enter ID# and enter name because more than one individual has the same name.

but when the name and ID# entered is not in the database the report displays with no info

I would like that if the parameters entered does not correspond to the info in the database for it to tell the user this and ask them to enter the information again

[ajetrumpet]

what have you tried?

[Nixx1401]

I created a query and entered the following parameters [Please enter name (first then last)] and [Please enter ID#] this displays the the correct information once the parameters enters corresponds to info in the database if that data entered does correspond to data in the database the report is blank

[ajetrumpet]

there is no option to check criteria in a parameter query. However, you can add code behind the report's OPEN or LOAD event to close itsself and re-open it. That's the way I have done it in the past.

not elegant, but it works.

[Nixx1401]

I am not too code savvy can you post the necessary code please

[ajetrumpet]

something like:

if me.recordsetclone.recordcount = 0 then
   docmd.close
      msgbox "The params entered result in no data. Reenter"
         docmd.openreport me.name
end if

[June7]

This is why I don't use parameter queries. I build forms for user to enter criteria then code behind the form opens report only if criteria is valid. Use combo and list boxes to control user input. More user friendly, less frustration. I use the WHERE argument of DoCmd.OpenReport to pass the filter criteria to report. Be aware, the more user friendly the more code.