DoCmd.PrintOut

[Aubrey]

Hi All,

I have a button on a form that should, when pressed, save the form and print it out.

However at the moment it prints out all forms. I was wondering if anyone could tell me the code to print out the current form only?

Thanks in advance

James Aubrey

 

[boblarson]

Actually, forms are not really efficient for printing. Normally one would create a report that looks like the form to print as reports are meant for printing. You could try filtering the form first so that only one record is there.