Report that selects a single record

[MStadnik]

I have a query that pulls field from multiple tables to create an "emergency
form" report. I virtually would never have the need to run a report listing
every record's emergency information. Instead, I would only need to be able
to pull up a report showing this information for one client at a time
generally. What is the simplest way to have the resulting report give me just
one record that I select? I'm not even sure if this is something that would
be done in the query itself or within the report. It seems like it should be
easy but I'm not finding it in my books... thanks.

MStadnik

 

[Jeff Boyce]

One approach is to add some code to a form from which you "order" the
report. If you are only working with queries so far, the forms-oriented
approach will be more work, but unless you add a "PickMe" field and set that
for the single record you want to send to the report, I'm not aware of a way
to do that.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MStadnik]

Thanks - it looks like this is something I'll wait a while on. I think I'm
getting sidetracked by details that are probably best left to later in the
process. I'll keep this info handy for when I'm ready to fine tune things.

 

[code_hungry]

MStadnik,

I just saw your posting today and I noticed no one had been able to give you
the answer you were searching.

I will give you an example of something I did for myself. So I hope this helps

There are three objects involved:
Report, Form, and Query. The form named “frmMyForm†has a text box that
contains the data that you want to base your report on. The name of my text
box is “txtMyTextâ€. In the query, you will type Forms![frmMyForm].[txtMyText]
in the criteria of the field that you will base your report on.

Create a button that will run the report that is based on the query that has
the criteria above and you will get the report for the current data displayed
on your form. In my case, the query that is the data source for my form is
not the same query that is the data source for my report.

Hope you see this reply.

Good luck