Preview from a form

[Guest]

Hi eveyone,

I'm having a problem sorting out how to carry out a print preview on a form,
if the form is opened on its own then I have 30K+ Records, if the same form
is opened from another form then I get one record, now which ever way I open
the form if I do a print preview from a command button then I get a report
that is in excess of 170K pages, where all I really want is for the selected
record, I'm using A97

MTIA

 

[Douglas J. Steele]

Realistically, forms aren't intended to be printed: that's what reports are
for.

Access has a built-in method to convert a form to a report. You could use
that, then pass the id of the current record when you issue the OpenReport
command.

 

[Guest]

Hi,

I have a report set up which I open from a command button on the form what I
want todo is open the report with the selected record being the only one
showing for printing