Creating / enabling a filter button on a form.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000 to create a database which is to be used by a variety
of people of varying abilities!

I have created the necessary forms etc and have reached the stage of putting
command buttons onto the forms to enable the users to perform a "Filter by
form" and subsequenty apply the filter.

I have created a macro to call the "filter by form" command which works
however after the user has entered the data into the form the second button
which has an associtaed macro to apply the filter is disabled and hence the
filter cannot be applied. (although the toolbar button to perform the same
function is still enabled!)

I know that there is a perfectly good set of buttons on the toolbar already
but I wanted to make the functioning of the database as idiot-proof as
possible by providing nice big buttons to do the neccessary functions.

So does anyone know why the button to apply the filter is disabled and how I
can make it work! (Ideally without the need for 20 pages of VB script!)

Thanks
 
John said:
I am using Access 2000 to create a database which is to be used by a
variety of people of varying abilities!

I have created the necessary forms etc and have reached the stage of
putting command buttons onto the forms to enable the users to perform
a "Filter by form" and subsequenty apply the filter.

I have created a macro to call the "filter by form" command which
works however after the user has entered the data into the form the
second button which has an associtaed macro to apply the filter is
disabled and hence the filter cannot be applied. (although the
toolbar button to perform the same function is still enabled!)

I know that there is a perfectly good set of buttons on the toolbar
already but I wanted to make the functioning of the database as
idiot-proof as possible by providing nice big buttons to do the
neccessary functions.

So does anyone know why the button to apply the filter is disabled
and how I can make it work! (Ideally without the need for 20 pages of
VB script!)
Click to expand...

You can't put anything on the "Filter by form" view of your form that will do
anything. Use the toolbar. Anyone incapable of using a toolbar is not capable
to construct a valid filter anyway.

(BTW, the VBA code used in Access is not VB Script)
 
Back
Top