I have a command button on my form that runs a macro. The macro's action is Apply Filter with the Where Condition being [Forms]![myform]![myfield]="mycriteria". This filter returns 0 records. If I right click myfield on the form and enter my criteria in the Filter for: box all works OK. What am I missing here?