Can I apply a filter on the subform? With my main form, called frmoffers, I choose the customer and then with the subform I choose the products.I want to place a button on my main form to choose the supplier, for example:
strFilter = "products.supplierid = 1"
Me.Filter = strFilter
Me.FilterOn = True
But how can I refer to the subform and can i filter it?
strFilter = "products.supplierid = 1"
Me.Filter = strFilter
Me.FilterOn = True
But how can I refer to the subform and can i filter it?