Hi everyone,
I have a problem synchronizing two list boxes on a form. I want to
display information in the second box based on the selection in the
first box. First box (List0)lists all company names from table that
lists quotes. I diplay a company only once even if it is listed more
that one time. The second box (List4)should display quotes for a
selected company (one or more.) Here is what I have for AfterUpdate in
the first box:
Private Sub List0_AfterUpda te()
Me.List4.RowSou rce = """SELECT QuoteId FROM" & _
" Quote WHERE AccountIdName = " & Me.AccountIdNam e & """ ORDER
BY QuoteId"
Me.List4 = Me.List4.ItemDa ta(0)
End Sub
I use double quets here because I read here on google that if my field
is not numeric or bulean I need to put qotes around it. Without qotes I
get the same error message as with. When I run it I get the following:
Syntax Error (Missing Operator) in Query Expression 'AccountIdName =
Advanced.....' (the name of one of our clients in listed.) Any idea
what is missing?
Thanks,
Stan