Filter by form using command buttons

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

How can I make a filter by form command button?

Also a unapply filter button.

Thanks.
 
WOW! Thanks!

Rosco said:
For your filter by form
Create a command button
In the On_Click event:

DoCmd.RunCommand acCmdFilterByForm

For your unapply filter button
Create a command button
In the On Click event:
DoCmd.RunCommand acCmdRemoveFilterSort
DoCmd.RunCommand acCmdFilterByForm

See the "RunCommand Method Constants" section of the Access help files for other commands

Rosco
Click to expand...
 
You must log in or register to reply here.

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

Similar Threads

QAT & Filter By Form 1
Filter by Form 1
Access Access 2010: Activating controls in a form after filter by form 0
How to change .Filter or .FilterOn 7
Apply Form Filter button 1
Too many forms? 3
Filtering Subform using option buttons on main form 3
Filter Report from Command Button 2

Back
Top