I have a form with 5 subforms. Each record on the primary form shows a person (AR_ID is the unique ID). Each person is assigned to a Unit (UnitID) which may be shared be many people. Each subform lists POCs assigned to their specific unit. Each subform is linked to the primary form via the UnitID. No problems.
On top of the primary form I have button, with a command to print a report for that specific person … person info and POC information.
I’m having difficulty printing the report with the correct information. Here’s what I’m using …
DoCmd.OpenReport "rptExpandedViewOnePerson", acNormal, , "[UnitID] =" & Forms!frmExpandedView!UnitID
I know I need to somehow call AR_ID but I don’t know how in my statement. Any help would be appreciated.