Printing a Form???

  • Thread starter Thread starter Wolfe
  • Start date Start date
W

Wolfe

Is there an easy way to print an Access form? The form has a header section
and detail section. The detail section contains three sub forms that pull
off of the header section. What I would like to do is kind of a screen shot
when a user clicks a print button.

Thanks,
WOLFE
 
Forms are designed for data entry and display. Reports are designed for
printing. You should build a report in the format you'd like and then have
the button print the report. You can even use a filter to have it print
only the current record.

Rick B


Is there an easy way to print an Access form? The form has a header section
and detail section. The detail section contains three sub forms that pull
off of the header section. What I would like to do is kind of a screen shot
when a user clicks a print button.

Thanks,
WOLFE
 
It might be easier to create a report with the layout that you want.
Imitate the form if necessary. Then have your button open the report with
fiter criteria of the key values on our form.

Make a button on your form that calls the report. The wizard will build the
code for you but you must write the filter critera (stLinkCriteria)

An example from one of my forms

Dim stDocName, strPO, stLinkCriteria As String

stDocName = "POReceived"
strPO = Trim(Str(Me.PurchaseOrderNumber))
stLinkCriteria = "[PurchaseOrderNumber]=" & strPO

DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
 
This is what I would normaly do, but since the users want to be able to print
the screen, I need a way to print a form.

Thanks,
WOLFE
 
Back
Top