opening report

  • Thread starter Thread starter cam
  • Start date Start date
C

cam

I hava a form that diplays information about employees
controlled by their initials. I also have a report with
the same info also controlled by initials. How can I open
the report from the form but only the display the report
for the currently viewed employee and not all of them.

Thanks.
 
Pass a Where condition in the Open Report call.

Example:
DoCmd.OpenReport "ReportName", acViewPreview, , "[Initials]='" &
Me.[Initials] & "'"
 
Back
Top