var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Print report to show a particular record
I have a report query that shows all my records in a certain order.
I would like to customise the report so i can have a button on my form so that if i am looking at a particular record it will only print that record and no other.
Can someone please tell me or guide me in the right direction.
Im guessing i have to pass some kind of parameter into the report query.
Thanks for your reply pbaldy.
but i dont want to see the detail in another form, i just want it to be shown in a report, in order for me to print it. any ideas? or have i completely missed what your explaining to me?
OpenReport "ReportName", acViewPreview,, "PrimaryKey = " & FormPrimaryKey
Something like that, but you might need to check the number of commas... and substitute all things like "ReportName" and "PrimaryKey".
Owner and Manager of
CypherBYTE, Microsoft Access Development Specialists.
Microsoft Access MCP.
And all around nice guy!
"Heck it's something understood by accountants ... so it can't be 'that' difficult..."
"...teach a man to code and he'll be frustrated for life! "
As I noted in the link, the same technique is available for OpenReport.