[AccessD] SQL Error

Hi All,

Can anybody help with the following line of Code. I created the SQL part
directly from the query window but I keep getting the error "Expected end of
statement at the "WO1" area

Me.Combo6.RowSource = "SELECT DISTINCTROW Member.[Regt Number], Member
Surname, Member.Rank FROM Member WHERE ((Not(Member.Rank)= "WO1")) ORDER BY
Member.Surname;"


Basically its a dropdown box that needs to leave out certain record
depending on the members rank

Any thoughts