Unanswered: Help searching subforms
I would like to build a separate form that accepts criteria to search fields in a form's subform. When you press search the main form is pulled showing all records that contain the subform information searched for.
I am able to do this for fields that are part of the main form but I have been unable to pull up records when I search for subform field data. I can't seem to pull the data that is related on the main form.
It would seem to me I would be able to search the subform by setting the link criteria to:
"Forms![frmMainForm]![frmSubForm].Form![subFormFieldIWantToSearch] = " & Me![UserEntryDataFromSearchPage]
but when I try to open the form by
DoCmd.OpenForm stDocName, , , stLinkCriteria
it pulls up no records (when I am certain there are results to be found).
Can anyone help with this?
Clinical Programmer Analyst
Wellstat Biologics Corporation