Find - how to successfully search for record(s) by using more than one search word?

[StargateFanFromWork]

In a typical form, if a user clicks into the field they're going to do a
search on, how can we do a search for more than one word? I checked in the
help and found very interesting info re parameter queries which I will
pursue. But just for right now and working with the forms we have, is there
any way to specify in the find box a search for 2 words, say, in any order
in a form?

Thanks so much! D

 

[Allen Browne]

Click the Toolbar button for Filter By Form.

In this view, enter the first keyword in the field, with wildcards, e.g.:
*Bush*

At the bottom of the Filter By Form screen is a tab for Or.
Click that, and you get a fresh page where you enter the next keyword, e.g.:
*Carter*

Apply the filter.

 

[StargateFan]

Click the Toolbar button for Filter By Form.

In this view, enter the first keyword in the field, with wildcards, e.g.:
*Bush*

At the bottom of the Filter By Form screen is a tab for Or.
Click that, and you get a fresh page where you enter the next keyword, e.g.:
*Carter*

Apply the filter.

Ah, okay. So there isn't a sequence of symbols we can use (i.e, like
in a windows explorer search), we need to use a completely different
search technique via the Filter By Form.

I'll advise my colleagues at work. They were the ones who came to me
with this question yesterday.

Thanks!

 

[Allen Browne]

Well, Filter-by-Form is the built-in technique.

You can program your own by genrating a WHERE string for the form's Filter
property, from the values, e.g.:
Me.Filter = "([Field1] Like ""*Bush*"") OR ([Field1] Like ""*Carter*"")"
Me.FilterOn = True

 

[StargateFanFromWork]

Well, Filter-by-Form is the built-in technique.

You can program your own by genrating a WHERE string for the form's Filter
property, from the values, e.g.:
Me.Filter = "([Field1] Like ""*Bush*"") OR ([Field1] Like ""*Carter*"")"
Me.FilterOn = True

Kewl, I'll have to try that. Tx.