print current record

S

Song Su

I have a form to display record. My primary key is 'serial'
I also have a rptComputer set up which primary key is also 'serial'

I want to put a button on the form and it would fire report preview for just
that particular record.
 
K

Ken Snell \(MVP\)

Send the specific primary key value to the report:

Private Sub ButtonName_Click()
DoCmd.OpenReport "rptComputer", , , "Serial=" & Me.Serial.Value
End Sub
 
Top