I think your problem is "" vs " " i.e. that is where you probably intended to insert a space. FWIW I prefer this format as it's less cluttered:
Code:
str = "SELECT tblExpenses." & Me.cboField & " From tblExpenses GROUP BY"
str = str & " tblExpenses." & Me.cboField & " WHERE (((tblExpenses." & Me.cboField & ")"
str = str & " Is Not Null)) ORDER BY tblExpenses." & Me.cboField & ";"
I don't see how what you posted could work with a line continuation character in the middle of a line, but then again, I don't use them, so...
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.