Openform subform filter
Posted on 2011-03-07
I have a main form, frmMain, with a subform, sfrmJobInfo. On the main form, I have a combo box that says find PO Number (it queries the data in PO number field in the subform). On the afterupate event for the combobox I want the code to pull up the records in the subform. This does not work.
stDocName = "frmMain"
stLinkCriteria = Me.[sfrmJobInfo].Form.Filter = "[PO Number]=" & Me.[PO Number]
DoCmd.OpenForm stDocName, , , stLinkCriteria