Lookup field display

[LaughingBull]

I have not had any luck thus far. Let me try to explain again.



I have a table, tblFamilyNavigator
ID Key, Mentor1, Mentor2, Mentee1, Mentee2, StartDate, CloseDate, MentorNotes

The mentee and mentor fields are lookups and there are 4 queries one for each field that filter from the people table to select only those that are mentors and mentees, by ID FirstName and LastName

I created a form for this Family Navigator table and when I select a mentee or mentor it only shows the ID number. I want it to show just the First and Last Name.

[June7]

Combobox properties:

RowSource: SELECT ID, LastName & ", " & FirstName AS FullName FROM People ORDER BY LastName, FirstName;
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0";2"
ControlSource: appropriate field to save ID into

http://datapigtechnologies.com/flash...combobox3.html

[CJ_London]

don't think you need the quotation marks here

RowSource: SELECT ID, LastName & ", " & FirstName AS FullName FROM People ORDER BY LastName, FirstName;


Should just be

RowSource: SELECT ID, LastName , FirstName AS FullName FROM People ORDER BY LastName, FirstName;
BoundColumn: 1

[June7]

No, I am concatenating the two fields so both name parts will be displayed in the combobox. The quote marks are to define literal text (the comma) to include a comma in the displayed value.

If they are not concatenated the properties would be:

ColumnCount: 3
ColumnWidths: 0";1";1"

And only LastName would display in the box. And the AS Fullname alias would not be needed.

[LaughingBull]

got it thanks for all your help

[CJ_London]

oops - missed that

[linco]

Hello!

I am a Newbie here. I think this answers my question, but not sure how to use it!!

Do I need to create the column FullName, and if so, where? Does it go in the table that I am pulling the First and Last name from or the table that I am loading with my form? I have successfully created a Combo box but when the User chooses, it them only shows the Last Name


thanks,

Lin

Combobox properties:

RowSource: SELECT ID, LastName & ", " & FirstName AS FullName FROM People ORDER BY LastName, FirstName;
BoundColumn: 1
ColumnCount: 2
ColumnWidths: 0";2"
ControlSource: appropriate field to save ID into

http://datapigtechnologies.com/flash...combobox3.html

[pbaldy]

The field is created on-the-fly in the combo's row source:

LastName & ", " & FirstName AS FullName