MS Access 2002 Forms applying a filter with command button allowing a field from that form with a wildcard
Posted on 2003-04-01
MS Access 2002 Forms - How do you:
Apply a filter with command button allowing a field from that form with a wildcard. problem: Filter by Selection selects by exact field value.
assuming I'm in a record where field [last name]= "smith"
how can i structure command button that filters with a wildcard (Smith*) so I get all Smith, Smithson, Smith Jr., etc....
the command button would work on any record so if [last name] = "jones", it would work same way.