filtering a datasheet form

[Yumex85]

Hi
I have a form that loads a table in datasheet format. One of the
columns is Yes/No (checkbox). If i use the "filter by selection"
button in the menubar, of course it wont show the whole table, only
the A type things for example. And suppose i wanna check all the 100
lines checkboxes of A type things. How can I do it?

 

[Guest]

You can accomplish this two ways -

1) Perform a 'Filter For' by right clicking in a field, then repeat this
action for other fields you want to apply a filter to. When doing this the
second filter filters the results of the first filter, not the entire table
behind the form

2) Click the 'Filter By Form' button just to the right of the middle of the
toolbar in Form view (not Design view). Here you can enter criteria in one
or all fields of your choosing.

Seth Schwarm