Print current record on specific report

[spectraflame]

I have a form that allows for entry of service order information. I currently have a print button at the bottom of the form, but when I click it, it is printing the form that is open which I guess that it what is suppose to be doing.

What I would like to do is to print the current record information on a specific report that I have created. I would still like to have a print button at the bottom of the entry form screen, but I need the record printed like the report instead of like the form layout.

Does this make sense?
Matthew

 

[bat17]

If WorkOrdertbl is Numeric try this one :-
DoCmd.OpenReport "WorkOrderrpt", A_NORMAL, , " [WorkOrdertbl] = " & [Forms]![WorkOrderfrm]![WorkOrdertbl]


If it is text then try this :-
DoCmd.OpenReport "WorkOrderrpt", A_NORMAL, , " [WorkOrdertbl] = '" & [Forms]![WorkOrderfrm]![WorkOrdertbl] & "'"

HTH

Peter

 

[spectraflame]

I got it figured out now. Thanks for sticking with me.

Matthew