Printing just the current record of a subform

Hello!

What's the best way to make a button print *just* the selected
(displayed) record of a subform, when that subform is currently part
of a larger form?

Thanks!

Re: Printing just the current record of a subform

"Dave" wrote in message
news:8b443dfe-d093-4b60-aa6c-7c8924b2205e@b40g2000prf.google groups.com...
> Hello!
>
> What's the best way to make a button print *just* the selected
> (displayed) record of a subform, when that subform is currently part
> of a larger form?
>
> Thanks!

Not sure if there is a best way to print a form. You ought to be printing a
report.

However, here's one way. Filter the subform so it has just the record you
want in its recordset, print the form, then switch off the filter:

With Me.SubformControlName.Form
.Filter = "FieldName = "
.FilterOn = True
End With

'Do the print out

Me.SubformControlName.Form.FilterOn = False

Re: Printing just the current record of a subform

Here is a way to do it manually. Maybe someone can enlighten us on how
to do it programatically.

When you are sitting on any form in form view (execution). go to the
menubar and select
file
print preview.

This brings up a print preview of what is on the screen with a
(questionable) option of printing it as is or just printing the data
part (without column headings or labels)

Ron

Re: Printing just the current record of a subform

I found where I had done it on a button:


DoCmd.RunCommand acCmdPrintPreview




Ron