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
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