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!NameOfYou rForm!NameOfTex tBox & "*"
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"jeffgeorge " <ki*******@aol. com> wrote in message
news:4f******** *************** ***@posting.goo gle.com...

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