open a query and display certain records

[Coll]

I have a form that had been setup with a combo box. You'd select a
value from the combo box and a query would open and display matching
records. I now need to remove the combo box and set up a text box so
the user types in a value and the query opens displaying any records
that contain that value in the field. For example, the user enters
"smith" in the text box. The query opens, and filters for any records
that contain *smith* in the name field - since it employs wildcards
and is not an exact match, I'm not entirely certain how to approach
this.

[Jen P.]

Coll wrote:

I have a form that had been setup with a combo box. You'd select a
value from the combo box and a query would open and display matching
records. I now need to remove the combo box and set up a text box so
the user types in a value and the query opens displaying any records
that contain that value in the field. For example, the user enters
"smith" in the text box. The query opens, and filters for any records
that contain *smith* in the name field - since it employs wildcards
and is not an exact match, I'm not entirely certain how to approach
this.

Hi, Coll :)

I've set up that very thing on a database we use. If using just one
searchable field, I found the easiest way was to make the 'find' button
run a form-opening macro where the 'Where condition' is:

[ta_people]![surname] Like '*' & [Forms]![Main
Menu]![find_by_surname _box] & '*'

Only, you know, with your own tables, fields, and form names. ;)

So, my users can type 'smit' in the search field and it'll find: Smith,
Nesmith, and, erm, other things that contain 'smit' in any part of the
surname field. :)

Hope this is helpful. :)

-Jen

[Coll]

On Oct 20, 5:35*am, "Jen P." <jp337sp...@cam .ac.ukwrote:

Coll wrote:

I have a form that had been setup with a combo box. You'd select a
value from the combo box and a query would open and display matching
records. I now need to remove the combo box and set up a text box so
the user types in a value and the query opens displaying any records
that contain that value in the field. For example, the user enters
"smith" in the text box. The query opens, and filters for any records
that contain *smith* in the name field - since it employs wildcards
and is not an exact match, I'm not entirely certain how to approach
this.

Hi, Coll :)

I've set up that very thing on a database we use. *If using just one
searchable field, I found the easiest way was to make the 'find' button
run a form-opening macro where the 'Where condition' is:

[ta_people]![surname] Like '*' & [Forms]![Main
Menu]![find_by_surname _box] & '*'

Only, you know, with your own tables, fields, and form names. ;)

So, my users can type 'smit' in the search field and it'll find: Smith,
Nesmith, and, erm, other things that contain 'smit' in any part of the
surname field. :)

Hope this is helpful. :)

-Jen

Will this approach still work if my button opens a query rather than a
form? Thanks.

[jonceramic]

On Oct 21, 6:37*am, Coll <col_mcma...@ho tmail.comwrote:

On Oct 20, 5:35*am, "Jen P." <jp337sp...@cam .ac.ukwrote:

Coll wrote:

I have a form that had been setup with a combo box. You'd select a
value from the combo box and a query would open and display matching
records. I now need to remove the combo box and set up a text box so
the user types in a value and the query opens displaying any records
that contain that value in the field. For example, the user enters
"smith" in the text box. The query opens, and filters for any records
that contain *smith* in the name field - since it employs wildcards
and is not an exact match, I'm not entirely certain how to approach
this.

Hi, Coll :)

I've set up that very thing on a database we use. *If using just one
searchable field, I found the easiest way was to make the 'find' button
run a form-opening macro where the 'Where condition' is:

[ta_people]![surname] Like '*' & [Forms]![Main
Menu]![find_by_surname _box] & '*'

Only, you know, with your own tables, fields, and form names. ;)

So, my users can type 'smit' in the search field and it'll find: Smith,
Nesmith, and, erm, other things that contain 'smit' in any part of the
surname field. :)

Hope this is helpful. :)

-Jen

Will this approach still work if my button opens a query rather than a
form? Thanks.- Hide quoted text -

- Show quoted text -

Coll,

Not sure if it will or not. But if it doesn't, you can always create
a form that looks exactly like the query using the form wizard with
the query as the source. If you'd rather show it as a datasheet view,
then people would never know the difference.

You could also write the query so that the criteria box for your query
field contains the "like" concatenation she showed. The only problem
is that you are permanently pointing to your form. And that's only a
problem if you want to reuse that query.

Jon