Filter on Form and Apply Filter

J

jimtyson

The users of a small database I'm building have asked me to put command
buttons for FilterOnForm and ApplyFilter on a form so that when
browsing records they can filter and apply. They maintain that the
toolbar icons aren't distinct enough and since all the other stuff is
done with buttons on the form (navigation, new record etc)it would be
consistent if they could do the filtering that way too.

OK, so I put a command button to:
DoCmd.RunCommand acCmdFilterByForm
on it's on click event. So far so simple. But I can't put the
ApplyFilter command on a button on this form because as soon as they
activate the event above all the control buttons become inactive.

I'm sure I'm missing something really simple but does anyone know if I
can put an apply filter button on a form in this way somehow?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top