printing one record

  • Thread starter Thread starter reportyemi
  • Start date Start date
R

reportyemi

I have created a report (called labor_report) of each record and would like
to be able to print one record at a time. When open the report, all the
reports are seen following each other. And so when i print from the form,
all the reports are printed. I just want the one to print that i look at
currently.

i have my event code below. When i click, nothing happens.

Private Sub print_button_Click()
Dim strlabor_record As String
Dim strWhere As String
strDocName = "rptSomeReport"
strWhere = "[maternal_ID]=" & Me!Maternal_ID
DoCmd.OpenReport strlabor_record, acPreview, , strWhere

End Sub

Please some advice please

yemi
 
I have created a report (called labor_report) of each record and would like
to be able to print one record at a time. When open the report, all the
reports are seen following each other. And so when i print from the form,
all the reports are printed. I just want the one to print that i look at
currently.

i have my event code below. When i click, nothing happens.

Private Sub print_button_Click()
Dim strlabor_record As String
Dim strWhere As String
strDocName = "rptSomeReport"
strWhere = "[maternal_ID]=" & Me!Maternal_ID
DoCmd.OpenReport strlabor_record, acPreview, , strWhere

End Sub

Please some advice please

yemi
Click to expand...

DoCmd.OpenReport stDocName, acPreview, , strWhere
 
Back
Top