Macro Help

[toleafs]

Hello
Any advice is appreciated.. I have a form with a combo box that filters records on the "AfterUpdate" event.

macroname: NameFilter
Conditions: [Forms]![Issues]![NameFilter]="Andrea" : ApplyFilter
[Forms]![Issues]![NameFilter]="Edlira" : ApplyFilter
[Forms]![Issues]![NameFilter]="All" : ShowAllRecords

The Where Condition is ="[First Name]=" & ([First Name]). First Name is the name of the textbox in the form that I would like filtered.

The problem I have having is that when I select from the drop down box is I get "syntax error (missing operator) in query expression '[First Name]='

Any IDEAS?????
THANKS

 

[mallard1976]

you could try including single quotes in your where condition, i.e.

="[First Name]='" & [NameFilter] & "'"

 

[toleafs]

thanks