Easy for some!

[Bradon]

As a newbie to access I have to create a command button that will send the data on a page to a report shell and print just that one record as a report.

Where do I start?

 

[Mudface]

Create your report and save it. Then, with the control wizard toggle depressed, draw a command button on your form, choose the open report action and give it the name of your report.

 

[Bradon]

Thanks Mudface,

The answer is always simple when you know how! Thanks again and good to see the English flag - beats a star circle any day.....

 

[Bradon]

Thought things were going too well!

I created the button using the method described and it shows the report layout I want but shows reports for all pages.

What I want to show is just the page that is relevant to the window open in the form at the time the button is pressed.

Any suggestions?

 

[Mudface]

The code to open a report also takes a WHERE parameter, set this to equal the current record on your form. This would look something like-

DoCmd.OpenReport "rptName", acViewPreview, wherecondition:="[uniquefield] = " & Forms!frmName!uniquefield

or, if your primary key is a string-

DoCmd.OpenReport "rptName", acViewPreview, wherecondition:="[uniquefield] = '" & Forms!frmName!uniquefield & "'"

Replace the various bits with as appropriate.

 

[Bradon]

Wow! Mudface,

I'm really glad you are out there - it worked a treat