Using 'like' on a user prompt

[RicDon]

I want to prompt the user for a value to use to filter a form. Here is my
command with the WhereCondition:

docmd.OpenForm "test", acNormal, , "LastName=[Enter a Last Name]"

I want to use the WhereCondition as a "LIKE" criteria. Variations on the
WhereCondition itself that I've tried include various combinations of

LastName LIKE %...%
LastName LIKE *...*
LastName LIKE [%...%]
LastName LIKE [*...*]

You get the idea...

No luck so far. Any thoughts?

 

[John W. Vinson]

I want to prompt the user for a value to use to filter a form. Here is my
command with the WhereCondition:

docmd.OpenForm "test", acNormal, , "LastName=[Enter a Last Name]"

I want to use the WhereCondition as a "LIKE" criteria. Variations on the
WhereCondition itself that I've tried include various combinations of

LastName LIKE %...%
LastName LIKE *...*
LastName LIKE [%...%]
LastName LIKE [*...*]

You get the idea...

No luck so far. Any thoughts?

LastName LIKE "*" & [Enter a last name, or part of one:] & "*"

 

[Dirk Goldgar]

I want to prompt the user for a value to use to filter a form. Here is my
command with the WhereCondition:

docmd.OpenForm "test", acNormal, , "LastName=[Enter a Last Name]"

I want to use the WhereCondition as a "LIKE" criteria. Variations on the
WhereCondition itself that I've tried include various combinations of

LastName LIKE %...%
LastName LIKE *...*
LastName LIKE [%...%]
LastName LIKE [*...*]

You get the idea...

No luck so far. Any thoughts?

Try:

Docmd.OpenForm "test", acNormal, _
WhereCondition:="LastName Like '*' & [Enter a Last Name] & '*'"