Retrieving one record

[pandaw1 via AccessMonster.com]

Hi,

I have a report set up sorted by Job Number. I want the user to be able to
retrieve and then be able to print all the report info for just one Job
Number. At the moment, my report lists all Job Numbers, so the user has to
scroll through to find the right one.

How can I do this?

Many Thanks.

 

[Al Campagna]

pandaw,
Several ways to do that.
I'll use an example of locating a particular JobNumber record on a form,
and running a report for just the JobNumber currently displayed on the form.
If your report is based on the JobNumber table, change that to a query
instead. That query should have a criteria against the JobNumber field
of...
=Forms!YourFormName!JobNumber
The criteria in the query forces the report to only report on the
JobNumber currently displayed on the currently open JobNumber form.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."