Hi,
I have a textbox - txtFilter - in the header section of continuous forms, in Events > AfterUpdate for txtFilter I've created a SetFilter macro to search the [Complaint] field on the continuous forms. What is the Where Condition to search for a word anywhere in this field?
I've tried -but when I enter a word in txtFilter and press Enter I get a box to "Enter Parameter Value" for txtFilter.Code:[Condition] like '*' & [txtFilter] & '*'
I want only those records that have the search term to appear in the continuous forms
Any help appreciated
David