Filter By Form via Code

G

Guest

I have a form that has a tab control and therefore several text boxes, combo
boxes, etc. I want the user to be able to search or filter by anything on
the form. I have a search button that evokes the DoCmd.RunCommand
acCmdFilterByForm, but once they enter in their criteria on the form they are
having to go to the toolbar to actually apply it because I am not quite sure
how to write it in code, plus there are some other things I want/need to do
once the filter is applied and again when its removed.

Thanks for any help
 

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 button 3
Screen blanks when record does not exist 2
Filter by Form limitations 4
Filter records with a form 1
Stop command button disabling with filter by form 8
Problem with Combo Boxes using Filter By Form and sending to Repor 2
Apply initial filter from within form without requerying 2
ApplyFilter with Access 2003 2

Top