reading a check box to apply a filter to a list form

[Turncloud]

I have a list view on my database and several check boxes on it. I want to click a button at the top of the form that restricts the view to only those rows that have that check box ticked. I just can't get the syntax right to make this work.

The form looks like this





and I'm trying to do an applyfilter command but whether I reference the control or the field I can't make it work - it just prompts me for the value most of the time.



What should I be putting in the applyfilter command ?

Simon

[NTC]

I would try: [cat_cables] = -1

Also one could right click and apply the filter that way....

Another approach is to use a query for the record source with the criteria for cat_cables to be <>-1 and then requery the form

[mrojas]

I would also try

If [cat_cables].value=true then
' apply filter or use the Record Source property and apply filter there, then requery
' You may have to requery the form
endif

[Dal Jeanis]

Try this -

DoCmd.ApplyFilter , "[cat_cables] = True"

http://msdn.microsoft.com/en-us/libr.../ff197651.aspx

[Turncloud]

NTC's answer worked - probably the others would have as well.