Generate a report from a specific record

[Charles Agin]

I am needing to see how I can have a report open up for a specific record.
For example, I have a form where users input inspection data for a site and I
have a button on the form that opens the appropriate report, but I would like
to limit the report to the specific record instead of all the records
associated with the same query. Any help is appreciated.

Thanks!

 

[Albert D. Kallal]

Just go:

me.refresh
docmd.OpenReport "nameofReprot",,,"id = " & me!id

 

[Charles Agin]

Excellent!! Thanks for your help!

 

[Charles Agin]

How would I be able to use the double click event for a text box in a subform
to open a particular form to specific record?

 

[Albert D. Kallal]

How would I be able to use the double click event for a text box in a
subform
to open a particular form to specific record?

code almost the same:

Just go:

me.refresh (only needed if editing occurs)

docmd.OpenForm "nameofForm",,,"id = " & me!id

Because users often don't know that they can double click a text box, I
usually place a command button (in continues form) to allow the user to just
have to do one click. Here is some screen shots of what I mean:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

(the 3rd, 4th, and 5h above screen shots have buttons that launch detail
forms. I could have used double click, but a button is more easy for the
user..and they can usually "guess" that clicking on the button will open a
form...where as double click means they have to be *told* to do that...and
that increases training for users....)