View Full Version : Printing from a command button


Jeff Mortimer
12-13-2000, 10:22 PM
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
12-14-2000, 03:37 AM
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.