Filtering from a textbox

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

Guest

How do I make a button to apply a filter that gets it criteria from a textbox?
 
Assuming you want to filter a form's recordset, try putting the following
code in the click event of your button...

me.filter = "YourField = " & textboxname.value 'if number
me.filter = "YourField = '" & textboxname.value & "'" 'if text
me.filter = "YourField = #" & format(textboxname.value,"mmm dd yyyy") & "#"
'if date

and then
me.filteron = true
 
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

Problem filtering 5
Vlookup from textbox 0
Using form to enter "query criteria" (between values) 2
Filter help 1
Using WHERE clause when launching Reports from Code 4
Filter Form doesn't close 2
Making a Button 1
Using 3 textboxes to filter a subform either together/independentl 4

Back
Top