Help on Passing form information into report to print

[indiana45s]

You guys were so helpful the last time, I decided to try again.

I would like to create a command button which prints the form.

However, I don't want to use the generic form print.

Rather, I would like to pass the form information through a query so I create a report with only the forms information. This way I can design the report to look more professional than the form. Presumably I use the KEY because it is the unique indicator of the record set.

However, I have no idea how to do this.

Any help would be greatly appreciated

 

[PHV]

Take a look at the 4th argument of the DoCmd.OpenReport method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886