passing variables to PrintOut

[Guest_imported]

How do I pass variables to the PrintOut command. I am using this within an Event Procedure triggered by on_click event
for a command button on my Access Form. Need to be able to
pass variables for Page Range, From, To parameters in the
PrintOut command. These are entered as unbound text fields
on my Access Form.

 

[AlexMidd]

If you have textboxes txtFrom and txtTo, pass their values to Integer variables, e.g. StartPage and End Page, then put these in as parameters expected by the PrintOut command,

Dim StartPage as Integer, Endpage as Integer

StartPage = Val(txtFrom)
EndPage = Val(txtTo)

e.g. DoCmd.PrintOut acPages, StartPage, EndPage, acHigh, 1
Have fun! )

Alex Middleton