Form to print as report

[CMooreJr]

Hey all...I have what I know to be a simple question, I just cant seem to figure it out. I have a form that I want all the data to print in report format.

What I want is a print button that will print just the data that is on the screen in REPORT format, not FORM format. The only way I can get it to work in report format is to query the data again by asking the user to input the data range, name, etc in a dialog box. This works, but I know there is a way to do it without asking the questions, since I have a primary key. Of course I can get it to print in FORM format with no problem, but that is not what I need...

can you help me with the code? Thanks!

 

[cranebill]

Cant you just open a report using criteria from the form instead of user input?

Build a query for the report datasource and use something like the following:

Select * From YourTable where YourField = Forms!YourForm!YourControl

Bill