vba - Trying to Filter a Form by Combo Box Value Error: "Syntax error (missing operator) in query expression -
i trying filter form based off of value selected in combo box. field trying filter called "wave" , combo box called cbowavefilter. using vba code below apply filter. tried both uncommented code , commented out code , still receive same error message. keep receiving error message "syntax error (missing operator) in query expression" when try select value in combo box. can't figure out causing error. went , checked query form built on (and subqueries that query built from) , can't find issue space in field name (which seems common solution problem). appreciated! thank you!
private sub cbowavefilter_afterupdate() 'docmd.applyfilter , "[wave] =" & me.cbowavefilter me.filter = "wave =" & me.cbowavefilter & "'" me.filteron = true end sub
Comments
Post a Comment