Printing single record from form view

[bfg]

Hi,

I have a form which contains recorded dates when pupils successfully complete tasks. The form finds an individual pupils record via a combo box in the form header. I would like to print the individual pupils 'record' however the Print button I have used actually prints ALL pupil forms. I know technically prints should be done via a Report but I don't want to spend time re-creating the layout etc of the form if there is an alternative method to get just the active pupil's record printed out from the actual Form.

[moke123]

Have you tried converting the form to a report?
https://www.lifewire.com/access-2013...eports-1019897

[Bob Fitz]

Have you tried:

DoCmd.RunCommand acCmdPrint

I'm not sure if this will print just the current record or perhaps all the records. If it prints all records then try applying a filter to the form so that you only have the current record before using the print command.

[bfg]

Thanks for the suggestion Bob but it prints all records.

[bfg]

Form converts to report ok but still generates ALL pupils. Thanks for the suggestion Moke123, much appreciated.

[Bob Fitz]

Thanks for the suggestion Bob but it prints all records.

Even if you apply a filter to the form first?

[moke123]

use the docmd.openreport method and use the where condition to limit the records
https://docs.microsoft.com/en-us/off...cmd.openreport

[bfg]

Now I feel really dumb ... I am now able to print the single selected record by clicking on the 'Print Pupil Record' button and from the printers options 'Print Range' ... 'Selected Records'. I was so engrossed in trying to find an Access solution I missed the blatantly obvious staring me in the face! Thanks for being so prompt in responding to my call for help... I promise to try and get my brain in to gear next time before I call for help.