Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter in the subform

Status
Not open for further replies.

mypeljo

Technical User
Apr 16, 2010
12
BG
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?
 
me.theSubformControlName.form.filter = strFilter
 
Thank you very much for the helpful advice!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top