Hello All,
Does any one know how to use the form filter in Access to provide partial match?
When you choose to "form filter," all text boxes will convert to combo boxes where you can choose from the already stored data in the corresponding tables. But for example I want to match all records containing the word John (assume it is a name field).
If there is a way to do this, it will save my life from having to write a big chunck of SQL code to achieve the mission especially with many fields on the form being matched against.
Appreciated.
- Hany