E
Elvis72
I have a subform that has a combobox with the following rowsource:
SELECT TblStaffRequirements[Title ID] & " - " & [Position Title] AS FullName
FROM TblStaffRequirements;
But the Title ID is an Autonumber and the Position Title is a Text field so
I am getting an error.
There has to be a way to show them both on the combobox on selection.
I have to have the Title ID on the Combobox as without it I cannot create a
new record on the Combobox.
Thanks for your help!~
SELECT TblStaffRequirements[Title ID] & " - " & [Position Title] AS FullName
FROM TblStaffRequirements;
But the Title ID is an Autonumber and the Position Title is a Text field so
I am getting an error.
There has to be a way to show them both on the combobox on selection.
I have to have the Title ID on the Combobox as without it I cannot create a
new record on the Combobox.
Thanks for your help!~