I have a problem printing my form, assume I am on the 4 form right now and I want to print this form, the database does not allow me to do that,it just print out all the forms that i have in my database.

I have try to put a page break after the form, it still have the same problem

Is there any recommended solution?

Thank you

Use a report which contains the data you require. Forms aren't meant for printing.

i have a report already, but user say that they need to print a copy of the form that they fill in, so I thought that they can print it directly from the form after filling all those particulars

If your user requires use to print the individual form you are on and in form view......


Use the command button wizard to add a command button. The wizard offers you actions for you command button. One offered is to Print current Record.


HTH

If they need it for training purposes, just run a screen shot.

Thanks jwindon

Actually I am running the printing through the Print Current Form command that I have created through the wizard

so do you think the best way for me to solve this problem is to choose the needed form and then design a report that looks exactly the same like the form?

You can Save as Report for your form.

There should be an option under RECORD OPERATIONS that offers PRINT CURRENT RECORD.....not the form.

Try a new command button.

Don't forget to save the current record in the click event of the PrintForm button before the PrintOut Method -

DoCmd.RunCommand acCmdSaveRecord

PS, I don't think the wizard generates the correct code for this. Look up the parameters for the PrintOut Method. I think you need to specify the first parameter - acSelection