DoCMD Printout

[trident]

I have a form that is continously growing.



I created a button to print the current data or any data I want (Current Screen)

How can I print the current page by using docmd.printout, below is the action I placed.

Private Sub Command70_Click()
DoCmd.PrintOut , 1, 1, , 1, NO
End Sub

Hope you can enlighten me on this.

Trident

[ranman256]

like you said, the form is too big....you must now use a report.
docmd.openreport "myReport",,"[id]=" & me.id

[Missinglinq]

Forms are for entering/viewing data...Reports are for printing out data, and as ranman256 said you need to create a Report for this.

Creating a Database is a job...and as is true in most jobs, the #1 Cardinal Rule is to always use the correct tool!

Linq ;0)>