query issue with parameters

S

Seede

Hi
I have a combo box and when i trigger a check box, i want the to run a
different query to populate the combo box. i am doing somethign wrong in this
code not sure what as i get a syntax error

Private Sub chkAllData_Click()
cmboSymbol.RowSource = "SELECT [TradeDiary].[Symbol] FROM [TradeDiary] " & _
" WHERE TradeDiary.Action <> #Ignore# ORDER BY
[Symbol];"




End Sub
 
K

Klatuu

What is #Ignore#?
The # delimiters will want to make it a date format
If you are looking for a string that is #Ignore# in the Action field, it
should be:
"#Ignore#"
 
Top