I have a form with a subform. and I want a Combobox on the form to filter the results on the subform.
The fom is called frmSets, the subform is subformBom the combo box is cmbSelectSet and I'm trying to filter it on the field parent_sku in a table called Bom, which the subform is based upon and the combobox is constructed from.
I currently have:
Private Sub cmbSelectSet_Change()
Me.subformBom.Form.Filter = "[bom].[parent_sku] = [forms]![frmSets]![cmbSelectSet]"
Me.subformBom.Form.FilterOn = True
Which I'm sure was working earlier today, but seems to have stopped working now with the error message of,