view a specific report based on the current info of a form

  • Thread starter Thread starter Arlene
  • Start date Start date
A

Arlene

Hi,

I have a form which has a subform, I added a command button on the subform
that will show a Report. But when I run a report it doesn't match the current
record on the form. How can I link the report's fields to the current record
show on the form?

I have to link several fields:

Tutor_ID
Effective_From
Effective_To
Area_Code

Thank you in advance for your help.
 
Save the record first, then open the report to that record:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "your-report-name",,,"Tutor_ID=" & Me.Tudor_ID
 
Back
Top