You need a field to uniquely identify the record in the form.
This example assumes it is and autonumber named ID.
Private Sub cmdPrint_Click()
If Me.Dirty Then 'save first
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print."
Else
DoCmd.OpenReport "MyReport", acViewPreview, , "ID = " & Me.ID
End If
End Sub
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"William Bradley" <br******@magma.ca> wrote in message
news:Bb********************@magma.ca...
What I need to have happen is, that when the form is filled out by the
user, the user can produce a report of that record only. Any help would be
appreciated.