Filter by Form

Sorry to have so many questions today but i keep coming up against problems.

I have found the best way to search my database the way i want is to use the filter by form function.

However, in the final build of the database, users will not have access to many of the functions on the toolbars so i would like to set the filter by form as a command button or similar.

How do i go about doing this.

Thanks very much

You need to create a command button but exit the wizard it launches. Then for the OnClick event of the button enter the following code:


To remove the filter create another button as above but use this code:


HTH