Limit OpenReport to Current Record

[Michael's Knight]

Windows 7 OS
Access 2013
I posted this question in the Macro discussion area, but perhaps it is more appropriate here:

I have a report that gives me an overview of my records, and i have built a report that gives me the desired details. I have created a button that will open the details report. When i open the overview report i get all the records in a list, when i click the button in any of the given records it will give me all the records details.
How can i limit the results to just the record i am clicking the button form (Current Record)?

 

[GinaWhipp]

You need to set your Criteria to such, i.e.

If your field is numeric...

DoCmd.OpenReport "YourReport", acViewPreview, , "[FieldInReport]=" & Me![ControlOnForm]

If your field is text…

DoCmd.OpenReport "YourReport", acViewPreview, , "[FieldInReport]='" & Me![ControlOnForm] & "'"

 

[Michael's Knight]

It is a text field,
I get a "compile error Expect end of statement" window, and its highlighting my command in the square brackets.

DoCmd.OpenReport "BookDetailsReport", acViewPreview, ,"[BookTitle]='" & Me! [Command20] & "'"

 

[GinaWhipp]

That is Command20? A button? You can't use a Command Button is criteria. What is the name of the field that holds the Book Title?

 

[Michael's Knight]

The field in the table is called BookTitle
As is apparent I know absolutely nill about coding

 

[GinaWhipp]

Hmm, still need to know... what is Command20?

 

[Michael's Knight]

I'm sorry,
Command20 is the command button i created to execute this action/open the report

 

[GinaWhipp]

That would be the problem. Where is says Command20 in the line you need to change that, in the line in Post 3, to a field on your Form that holds the Book Title.

 

[Michael's Knight]

It still wasn't working when i would place the Field name there either, so i re-made the field in the report and now it works!
Thank you so much!

 

[GinaWhipp]

Your welcome, glad to help!