form filter problem with checkbox

[elpico]

Hi all,

I have a continuous form, but I am having problems applying filters to it - I have a checkbox in the header of the form, which, when I tick it I want only values that match a condition to be displayed -

I've tried the applyfilter command without any luck...

DoCmd.ApplyFilter, Me!Output = 'True'

Also, when I unclick it, I want the form to be reset to its original setting...

- Currently it just seems to clear everything in the form...

Any ideas what I'm doing wrong?

Thanks,
e.

 

[PHV]

What about something like this:
Me.Filter = "[Output]=True"
Me.FilterOn = Me![checkbox name]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[elpico]

Thanks - I just figured it out too - It helps to read the help files a bit - To be honest the answer is nearly always there - The hard part is finding it!

Cheers,
e.