Printing from a command button

[Jeff Mortimer]

I want to print the current record in a form using a command button that uses a report format that I have designed ..... using HELP I have only been able to get it to print the current record as it appears on screen in Form itself .... There is a help topic on printing from a form using a command button but I am having trouble following its NOTE at the end on how to do it

 

[adamcort]

In the underlying query for the report set a criteria for a unique field (say account number).

the criteria should be;

[FORMS]![NAMEOFFORM]![NAMEOFCONTROLONFORM]

When the report prints out, it will only get the record that is screen, because that record will be defining the criteria.