Are these typos or this is the way your code looks, if the latter I'm surprised it even compiles...
it should be (and by the way, you don't need to prefix with the table name when there's only a single table in your query)
Also, 'key' is a keyword in SQL server, I'm not sure about Access
Dim strSQL as as string ="SELECT KeyPersonel AS myKey, (LastName & ', ' & FirstName) AS Contact FROM tblPersonel "