Print preview resets a form

[hosi]

Hi, suppose I want to print third record from my subform.
the problem is, that when I want to print what I actually see on my
monitor, the print preview resets
the form to the first record (wants to print the whole form beginning -
from the first record).
Is the any possibility to print a particular record, without making
screenshots?
Please, help me!!!

 

[Al Campagna]

Forms are not made for printing, and the "form" Print Preview is extremely limited.
You should create a report based on the form that returns the values you want.
But...
If you must print the form... and you want to print just record 3, then filter the
form's recordset to just that record, and the "form" PrintPreview.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[hosi]

If you must print the form... and you want to print just record 3, then filter the
form's recordset to just that record, and the "form" PrintPreview.

Thank you! This works perfect!

hosi