Print a form by itself?

[Don2k7]

How do you print a form by itself, everytime i try to print it prints all the records , its a form with a sub form.

I've searched google and this forum i coudnt find an answer , i even looked in a book it asked me to make a macro but that didnt even work! Help!

 

[missinglinq]

The simplest way is to go to File - Print and when the printing dialog box comes up select "Selected Record." I'll save someone else the task of responding by also saying that most of the time you really should use a report for printing.

 

[Don2k7]

The simplest way is to go to File - Print and when the printing dialog box comes up select "Selected Record." I'll save someone else the task of responding by also saying that most of the time you really should use a report for printing.

Is there a way to create a button to click and then it prints the current form?>

 

[WinDancer]

Can the selected record be done in VBA?

I am now using:

DoCmd.ApplyFilter , "surveynumber=Forms!frmTabSurvey!surveynumber"

Forms!frmTabSurvey!Page1.SetFocus
DoCmd.PrintOut
Forms!frmTabSurvey!Page2.SetFocus
DoCmd.PrintOut
Forms!frmTabSurvey!Page3.SetFocus
DoCmd.PrintOut
Forms!frmTabSurvey!Page4.SetFocus
DoCmd.PrintOut
DoCmd.Echo True
DoCmd.SetWarnings True

Anyone?

 

[manny_cb]

hey.. im pretty new to this myself.. but as soon as you draw a command button.. it takes u to the command button wizard.. and you can select form operations > Print a form or current form.. and it does the vba for you.. wud dat not work ?

 

[dkinley]

If you're not into making reports, you can write a windows macro to do a print screen, paste and print job I guess.

-dK