2 records - 1 output

[Guest]

In particular, I have two fields in one form/table

Surname
First Name

In other form I have a JobListing with a field Candidates Associated (which
is a combo box). How do I get the Candidates Associated to display both
Surname and First Name, with the option to scroll down to choose which
candidate needs to be displayed?

 

[Joan Wild]

In particular, I have two fields in one form/table

Surname
First Name

In other form I have a JobListing with a field Candidates Associated
(which is a combo box). How do I get the Candidates Associated to
display both Surname and First Name, with the option to scroll down
to choose which candidate needs to be displayed?

You would likely need more fields in order to uniquely identify the
candidate - i.e. Smith, Jim and Smith, Jim. If you have used an autonumber
(PersonID) as your primary key:

In the row source of the combo
SELECT [Surname] & ", " & [First Name] AS Candidate, [PersonID]
FROM MyTable
ORDER BY Surname, [First Name];

Properties for the combo box:
Bound Column - 2
Column Count - 2
Column Widths - 2";0"

 

[Guest]

Thank you very much!! That worked perfectly!!

In particular, I have two fields in one form/table

Surname
First Name

In other form I have a JobListing with a field Candidates Associated
(which is a combo box). How do I get the Candidates Associated to
display both Surname and First Name, with the option to scroll down
to choose which candidate needs to be displayed?

You would likely need more fields in order to uniquely identify the
candidate - i.e. Smith, Jim and Smith, Jim. If you have used an autonumber
(PersonID) as your primary key:

In the row source of the combo
SELECT [Surname] & ", " & [First Name] AS Candidate, [PersonID]
FROM MyTable
ORDER BY Surname, [First Name];

Properties for the combo box:
Bound Column - 2
Column Count - 2
Column Widths - 2";0"