View Single Post
  #1  
Old April 28th, 2010, 05:01 PM posted to microsoft.public.access.forms
samotek via AccessMonster.com
external usenet poster
 
Posts: 29
Default Filter in the subform

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?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201004/1