G
Guest
How do I make a button to apply a filter that gets it criteria from a textbox?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
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