They should be so simple but it's not working for me
I have a Form called employeesearch
It has 3 fields "id", "lastn","firstn"
I have a text box called "text39"
I have a button attached to a macro
Macro:
Setfilter
Filter name = {this is blank}
Where condition= [lastn] like "*" & [text39] & "*"
Control Name ={this is blank}
I just want to type the last name in the text39 box and filter the form by the macro
What am I doing wrong? Thanks for the help