Trouble when printing form. All records are printed...

  • Thread starter Thread starter Mr. Smith
  • Start date Start date
M

Mr. Smith

Hi.

A bit hard to explain but I'll try.

I have a form, where only one record from the data source is shown at the
time. If i try to print the form with "File->Print" Access sends all records
to the printer, and not only the one viewed on screen.



I've set the Default view to "Single Form", but I can not find where to set
the properties to only print current record when printing.



If any of you know how to deal with this I'll appreciate it if you share
your knowledge. Further I'm also interested in how I might use a VBA sub
assigne to a customized "print" button to print only page one of x (if there
is no common solution to my problem).



Yes, I know I should have used Reports, but in this instance I need to print
the form.



Any responses appreciated : )



Regards

Mr. Smith
 
Create a report based on the data source of the form.
Create a button to preview the report and filter the data using the
WhereCondition argument to match the viewed record..
 
It is best not to print forms at all as that is not really there purpose but
if you must when the print dialog come up use the "Selected records only"
option

Regards
Bruce
 
Back
Top