Query By Form (searching for non-exact fields)

[161]

Hello,

I'm currently using a form to search my entire database for values in a few different fields. Here is the template I'm following:


http://support.microsoft.com/kb/304428

The Problem is in part (5), where it does the query for an "exact" result. I have a description field that I want some flexibility in. So if I do a search for "paper", I want everything to pop up that has anything to do with paper. Like "paper clips" and "colored paper" etc.

Is there a way I can do a query for "similar" results, rather than "exact"?

[pbaldy]

You should have read down further. Try

Like "*" & Forms!FormName.ControlName & "*"

[161]

O wow, theres such a command... im a n00b. awesome, thanks!

[pbaldy]

No problemo!