Hi there!

I have a simple question. How can I apply a filter to a subform, clicking a toggle button on the main form?

(Records are located in the subform)

thanks in advance

GregoryHu

If it's just a standard filter, you could either:
a) Use the Filter button that's on the standard toolbar
b) put some code into your own button such as:
I am a loud man with a very large hat. This means I am in charge

On the button's ON CLICK event you can simply do this

Me.sfrMySuform.Filter = "[strMyField] = '" & Me.txtMyField & "'"

or

Me.sfrMySubform.Filter = "[intMyField] = 7"

or

Me.sfrMySubform.Filter = "[dtmMyField] >= #" & Me.txtMyDate & "#"

or whatever you want your field to equal.

Set the filter = "" to reset it back to all.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks , you helped me a lot


GregoryHu