query issue with parameters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seede - 31 Mar 2006 22:20 GMT

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

Reply to this Message

Klatuu - 31 Mar 2006 22:30 GMT

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#"

> Hi
> I have a combo box and when i trigger a check box, i want the to run a
[quoted text clipped - 9 lines]
>
> End Sub

Reply to this Message