go to mainform from subform on selected record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to go from a list view(subform) to a form view. I have
OpenForm frmCases

The following where clause doesn't work:
[tblCases]![CaseID]=[qryCaseListView]![CaseID]
I want to go back to the selected caseID record from the subform this query
is based on to the main form, when event is clicked.
thanks,
 
Janis,

If I understand you correctly...
[CaseID]=[Forms]![NameOfMainForm]![NameOfSubform]![CaseID]

If that doesn't work, please let us know more details. I am not
familiar with the term "list view". What is the name of the original
form and the subform, and what evetn are you running the macro?
 
Back
Top