Using wildcards in a ‘WHERE’ condition for ApplyFi (Access 97)

Topic

New Reply

Howdy,

A client of mine is using macros (I know, I know) to filter a table based on what’s been entered in a text box, using the ApplyFilter action.The argument looks like this:

[Human]![Name]=[Forms]![Primer form]![Text66]

Since the text box doesn’t list the items available to filter, he’d like to be able to use a wildcard. Simply prepending “Like” to the expression doesn’t work. What am I missing? Can a wildcard be used in the text box, and if so, how do I make that happen?

Thanks in advance,

Beej

Reply | Quote

Replies

You could try changing the text control to a Drop Down control based on a SELECT DISTINCTROW query. That way you would always have the current available search criteria.

Reply | Quote

Instead of a text box, you could use a combo box. But if you want to use wildcards, try this:

[Human]![Name] Like "'*" & [Forms]![Primer form]![Text66] & "*'"

Note the use of single quotes around the value.

Reply | Quote