Text Box Filter using LIKE

[jeffgeorge]

Trying to create a filter via a text box where users enter the first
few letters of possible names available. Text box would be connected
to a "LIKE *TEXTBOX*" statement which would filter all records which
match the "LIKE *TEXTBOX*". Sure it wouldn't be hard, but some of the
syntax is tripping me up.

Jeff

[fredg]

jeffgeorge wrote:

Trying to create a filter via a text box where users enter the first
few letters of possible names available. Text box would be connected
to a "LIKE *TEXTBOX*" statement which would filter all records which
match the "LIKE *TEXTBOX*". Sure it wouldn't be hard, but some of the
syntax is tripping me up.

Jeff

Jeff,
Where are you doing this?

In a query:
Where [LastName] Like "*" & forms!FormName!ControlName & "*"
The form must be open when the query is run.

On a form to filter the form?

Code the AfterUpdate event of the control:

Me.Filter = "[LastName] Like '*" & [ControlName] & "*'"
Me.FilterOn = True

These filters will return records that have the text anywhere within the
field.
--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.

[PC Datasheet]

Jeff,

Try putting the following expression in the appropriate field's criteria of the
form's query:

Like "*" & Forms!NameOfYourForm!NameOfTextBox & "*"
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"jeffgeorge" <ki*******@aol.com> wrote in message
news:4f**************************@posting.google.c om...

Trying to create a filter via a text box where users enter the first
few letters of possible names available. Text box would be connected
to a "LIKE *TEXTBOX*" statement which would filter all records which
match the "LIKE *TEXTBOX*". Sure it wouldn't be hard, but some of the
syntax is tripping me up.

Jeff