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.
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.