Quote Originally Posted by Gicu View Post
It would be if you were using forms, not sure about the reports. To "highlight' the record would mean to select it and to do that you would need to tell it what to look for (the MinerDetail or better the MinerID value). You could do that by using the OpenArgs parameter of the Docmd.OpenReport method you are using to open it (it is the last one):


Code:
'Docmd.OpenReport (ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)
Docmd.OpenReport "Breakers Sorted",acViewReport,,"[Panel ID] ='" & Me.Panel & "'",,Me.MinerID
Then in the Open event of the second report try to navigate to that record"
Code:
'use SearchForRecord 
Docmd.SearchForRecord acDataReport, Me.Name, , "[MinerID]=" & Me.OpenArgs
Cheers,
unfortunately that doesnt work, but its maybe because its within a report like you said. would've been too nice but not a big deal to look for it real quick manually
thanks!