You say you have tried
SQL1 = "SELECT Kontaktpersoner.Fornavn" & " " & "Kontaktpersoner.Efternavn"
but you don't say how you are executing the SQL which is necessary to get the result.
If your using Docmd.runsql then you wont get a result because it only works with action queries
http://msdn.microsoft.com/en-us/library/office/ff194626.aspxYou could use dlookup which you would obviously need to execute twice to get both name parts. Otherwise create a recordset selecting both fields at the same time
and your SQL needs to include the table your data is in.