Print a Report from a current Form entry

By james ·
Hello All,

I need some help to work out how I can Print a Report (invoice) from a Form that has just been entered in MS Access 2003.

i.e. Type in the information into a form and subform then click on a button a the bottom to print the invoice out using a form.

I hope someone can help.

Thanks a million.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by unhappyuser In reply to Print a Report from a cur ...

Set up a button on the form to print the current record.


Collapse -


by james In reply to Button

Could you please point me in the right direction of some code to do that as I can't seem to print just the current record, it seems to want to print all the records in the table.



Collapse -

Here goes

by unhappyuser In reply to Button

Open the form in Design View. Click on the button icon and choose Form Operations under Categories and Print Current Form under Actions. Choose Text or Picture for the icon and Finish.


Collapse -

print current field from form

by oss2010 In reply to Here goes

Private Sub ???43_Click()
' chek your id name on you db

If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If

If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
strWhere = "[ID] = " & Me.[id]
DoCmd.OpenReport "t1", acViewPreview, , strWhere
End If
End Sub

Related Discussions

Related Forums