ListBox Row Source Query With Global Var

[Auto]

hi, i have a form which has a combobox which the user needs to choose a phone number from a customer, after update, vba places the value in a variable, then i have listbox that needs to show up for the customer with all orders from that phone number.



so i placed a Sql string for the Raw Source in vba, but nothing pulls up, here is my code.

Dim SQL As String

SQL = "SELECT DISTINCT Orders.PurchaseDate, Orders.OrderID" _
& "FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.ID" _
& "WHERE Customers.Phone = '" & PhoneNum & "'"


Me.OrderList.RowSource = SQL
Me.OrderList.Visible = True

can anyone tell why its not working?
thanks in advanced.
​

[June7]

Need embedded space in the SQL string after Orders.OrderID and Customers.ID. Without embedded spaces the segments run into each other when concatenated.

[Auto]

oh man, you got it, how dumb am i

but it show up only the date, which is column 1, not the column 2 which is OrderID
how can i get both columns to show up?

[June7]

Set the ColumnCount and ColumnWidths properties of combobox.

[Auto]

got it, thanks a billion!