Stuck a problem with AddItem in my 2 column listbox
Found if Dat(1) contains a comma, it's used as field delimiter and fills both columns, without ever seeing Dat(0). How do I put each piece into it's own column ?
I did Google for this and found instructions to set the listbox Rowsource to a query.
But that just put the sql into the lists, not the result of the sql.
Code:
.Additem item:=Dat(1) & ";" & Dat(0)
Found if Dat(1) contains a comma, it's used as field delimiter and fills both columns, without ever seeing Dat(0). How do I put each piece into it's own column ?
I did Google for this and found instructions to set the listbox Rowsource to a query.
Code:
Me.List23.Rowsource = sql$