Button Issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have created a form, and have added a "View Report" button which displays
a report with all of the form data contained in it. There are 12000 records
and the way it displays the information is in client number order so that you
must next record to get to the one you want to view.

Is there a way to add a feature to the report so that the user can narrow it
down to one client number? Thanks
 
Go to de code behind the button. You will probably see something like:

DoCmd.OpenReport, "reportname", acPrintPreview

Place a comma and add the criteria you'd like to see. If you have a combobox
with the clientnumbers you can use that to filter the report:

"Where clientnr = " & me.combobox

or you could place a parameter in your query asking which clientnumber you
want to see.

in criteriafield of your query: [which clientnumber]
 
Back
Top