Locate record on form by matchin few characters in control

  • Thread starter Thread starter Access question
  • Start date Start date
A

Access question

I want to create a control on a form that when characters are entered in the
field, the results have those characters in it. For example, if we were to
type in “RTUâ€, it would be nice if the DB could list projects with that in
the project name or description, by client.
 
I want to create a control on a form that when characters are entered in the
field, the results have those characters in it. For example, if we were to
type in “RTU”, it would be nice if the DB could list projects with that in
the project name or description, by client.
Click to expand...

You chose not to post any description of your table structure or your form, so
I can't be very specific; but a query with a criterion such as

LIKE "*" & [Forms]![YourFormName]![YourControlName] & "*"

will search your table for substrings as you describe. How you would use this
query I don't know, since I don't know the context of your request.
 
Back
Top