Multiple fields in combo boxes

[Alex]

Is this possible please.
i have a combo box on a table which looks up data from another ytable, which
conjtains a FirstName and Surname field.
I want to concatanate the two fields together and place them in a field
within the first table.


My current code is this
Using: SELECT Lecturer.LecturerID, Lecturer.FirstName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];

 

[PC Datasheet]

SELECT Lecturer.LecturerID, Lecturer.FirstName & " " & Lecturer.Surname As
LecturerFullName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];

 

[Alex]

Thanks

SELECT Lecturer.LecturerID, Lecturer.FirstName & " " & Lecturer.Surname As
LecturerFullName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Is this possible please.
i have a combo box on a table which looks up data from another ytable, which
conjtains a FirstName and Surname field.
I want to concatanate the two fields together and place them in a field
within the first table.


My current code is this
Using: SELECT Lecturer.LecturerID, Lecturer.FirstName, Lecturer.Surname FROM
Lecturer ORDER BY [Surname];