My form displays customer data from a query. I want to filter the form's data (including wild card, *) and then refresh the form to display the filtered results. In the header section I have a text box for "name part" and a "Search Button" Depending on an option box, name part is either the first letter of last name(s) a character string appearing in last name(s). I know this should be simple but I am in the midst of a serious senior mement!
filter form data on the fly?
- Thread starter billyr
- Start date
What I would do is base the form on a query that uses this textbox for a parameter.
The criteria would be: Like Forms!FormName!TextboxName & "*"
Then all you have to do is use the button to requery the form.
You'll probably want the form to show all the records if nothing is in that textbox. In order to do that you'll need to write this criteria on the line below the other criteria:
Forms!FormName!TextboxName Is Null
The criteria would be: Like Forms!FormName!TextboxName & "*"
Then all you have to do is use the button to requery the form.
You'll probably want the form to show all the records if nothing is in that textbox. In order to do that you'll need to write this criteria on the line below the other criteria:
Forms!FormName!TextboxName Is Null
I'll leave well enough alone.
