I've searched high and low, and maybe it's my lack of terminology but basically here is the problem.
I have a dropdown combobox in a database that displays two columns from a different mdb file. In the combobox Row Source field I have - "Select OtherMDB.Surname, OtherMDB,FirstName FROM OtherMDB;"
What I want to do is select the data and for it to return in one field in the new MDB database "Surname, FirstName"
So basically add the two columns together as the result. Any ideas?