select rowsource problem (1 Viewer)

[bbwolff]

i have unbound combobox, to chose from a list of ppl

SELECT [name] & " " & [surname] AS Expr1, tblPpl.user FROM tblPpl ORDER BY tblPpl.UserType, tblPpl.user.Surname;

i want to add a button, that would change the default order from name+surname to surname + name

sthg like

me.combobox.rowsouce = ...

i have problems with adding the expression to this row

 

[namliam]

me.combobox.rowsouce = "SELECT [surname] & "" "" & [name] AS Expr1, tblPpl.user FROM tblPpl ORDER BY tblPpl.UserType, tblPpl.user.Surname; "

Like that!

 

[bbwolff]

perfect, tx
guess i missed " or two

 

[namliam]

Thing is the single quotes start and end the string...
The double qoutes escape the string and force the quotes inside the string. ending up with the SQL you are looking for