How do I search the forum?  I didn't see a search box anywhere in the forum pane. I am trying to make a hot link in a subreport to open a form on that record. I have tried several WHERE statements in a macro.
[ARR_ID]=[Reports]![rptPendingARR_AllYearsAllSpecialists]![Report]![subrptPendingARR_AllYearsAllSpecialists]![AutoNo]
[ARR_ID]=[Reports]![rptPendingARR_AllYearsAllSpecialists][subrptPendingARR_AllYearsAllSpecialists]![AutoNo]
I can manually enter a record in the parameter box that shows up in the error.  I have no trouble links in subforms to open a different form using a similar WHERE such as [RequisitionNum]=[Forms]![frmContractObligationsTracking]![sfrmContractObligationsTracking]![RequisitionNum]
I cannot figure out why I cannot create the WHERE in a subreport in a report to use the link in Report View.
The link in the subreport opens the form but does not pass the value of the AutoNo to the form's ARR_ID.

---

Reply from Alex Hedley:

There is a SEARCH box in the top right corner of every page.
Is the link in the main report or the sub report? Might just need the sub report value.