I want to add a command button that will let the users look for a record by FirstName + Last Name at the same time. The name field is separated not all together. Also I want to lookk up the name as anything close. i.e. Sue, Susan, Susie, etc.
Say I want to find Sue Smith. I want the command button to let me put in Sue Smith and it will look for Sue Smith, Susie Smith, Susan Smith. I imagine it to be something like Su* Smith???
Anyway.... I can put the command button on the form, that's no problem. My problem is how do I get it to do what I want it to? I posted a question similar to this a while back and the only response I got was no help to me. So am trying once again as i know no where else to turn for help.
Say I want to find Sue Smith. I want the command button to let me put in Sue Smith and it will look for Sue Smith, Susie Smith, Susan Smith. I imagine it to be something like Su* Smith???
Anyway.... I can put the command button on the form, that's no problem. My problem is how do I get it to do what I want it to? I posted a question similar to this a while back and the only response I got was no help to me. So am trying once again as i know no where else to turn for help.