Okay so I tried using this code but was unsucessful. I need to be able to serach for a record (which I can do) and just print that single record into a form without printing the whole database. Please any help would be greatly appreciated.

Private Sub cmdPrint_Click()
'Print current record
'using rpt1234.
If IsNull(Me!FNLastName) Then
MsgBox "Please select a valid record", _
vbOKOnly, "Error"
Exit Sub
End If
DoCmd.OpenReport "rpt1234", , , _
"FNLastName = " & Me!FNLastName
End Sub

------------------------------------------------------
FNLastName is how the form is selected via a search, however there may be a the same Last Name so each record has a Seq # that is autonumbered and not duplicated.

rpt1234 is which report format I want to use.