Apply Filter Macro

[SteveI]

Why does a dialog box (SEE ATTACHED) come up for an applyfilter macro written based on a query occur.

The where condition for the apply filter is as follows:

[INCI Name] Like "*" & [Forms]![INCI Name Search]![Text57] & "*"

:banghead:

Many thanks

 

[oleronesoftwares]

do it like this
create a form with the name INCI Name Search
create a text box on the form with the name [Text57]
then place a command button on the form that runs the query