Filter by selection

[Antonio]

I have a form that displays several records in Datasheet
form. On the form header I would like to place to
buttons. The first would "Filter By Selection" and the
second would "Remove Filter". I know this can be done by
righ mouse clicking, but I removed those options when the
database starts up (a customer request). Now, they still
want to be able to filter by selections, but with an on
and off button on the form. Is this possible?
TIA

 

[John Vinson]

I have a form that displays several records in Datasheet
form. On the form header I would like to place to
buttons. The first would "Filter By Selection" and the
second would "Remove Filter". I know this can be done by
righ mouse clicking, but I removed those options when the
database starts up (a customer request). Now, they still
want to be able to filter by selections, but with an on
and off button on the form. Is this possible?
TIA

Not, to my knowledge, on a Datasheet; but you can create a Continuous
form which looks just like a datasheet and gives you a form header in
which you can put such buttons.