how to apply filter by selection option thru code in MS Access

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

Guest

We can use filter by selection by selecting appropriate button. but it should
be achievable by using code once particular text box got focus. how to do
this.
 
If you want to use a CommandButton, use the following code in the Click
Event:

Screen.PreviousControl.SetFocus
' You need this since the CommandButton now has the Focus and
' and you need to send the Focus back to the TextBox
DoCmd.RunCommand acCmdFilterBySelection
 
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

filter form by listbox selection 1
How to apply the form filter on the report? 3
Multiple report filter using combo box on form 2
Apply Filter Macro in Form 3
Filter button 7
filter by multiple combo boxes 2
Access 2007 Apply Filter 3
Refreshing filter on Subform in Access 2010 0

Back
Top