lookup dropdown list

[LaughingBull]

I have a people table for all the people
I set a query to select only those that are Family Navigator Mentors ID,FName,LName
I use this query for a lookup on the family navigator table to select a mentor


on the form I want the ID FName and LName to show up not just the ID.????

[June7]

Recommend combobox properties:

RowSource: SELECT ID, LName & ", " & FName AS FullName FROM tablename ORDER BY LName;
BoundColumn: 1
ControlSource: as appropriate to save ID
ColumnCount: 2
ColumnWidths: 0";2"

Expressions in textboxes can reference combobox columns by index. Index begins with zero.

=[comboboxname].[Column](1)

[LaughingBull]

the combobox on the form properties are SELECT [FamilNavigatorMentorQuery].[ID], [FamilNavigatorMentorQuery].[FirstName], [FamilNavigatorMentorQuery].[LastName] FROM FamilNavigatorMentorQuery ORDER BY [LastName]; but only the ID shows up

[June7]

Need to set ColumnCount and ColumnWidths properties as suggested.

Recommend concatenating LName and FName.

[LaughingBull]

here is the options for the properties Column Widths is not an option

[June7]

On the Format (or All) tab.

[LaughingBull]

I set it all like you said the SELECT [FamilNavigatorMentorQuery].[ID], [FamilNavigatorMentorQuery].[FirstName], & ”,” & [FamilNavigatorMentorQuery].[LastName] AS FullName;FROM FamilNavigatorMentorQuery ORDER BY [LastName]; and I get this error message when I click the down arrow to select a mentor

[June7]

Remove the comma (,) after [FirstName] in front of &. Remove the ; in front of FROM, put a space in there.

Look at my example again - I corrected it to remove my typo on the bad ;.

[LaughingBull]

SELECT [FamilNavigatorMentorQuery].[ID], FamilNavigatorMentorQuery.FirstName & [”], [”] & FamilNavigatorMentorQuery.LastName AS FullName FROM FamilNavigatorMentorQuery ORDER BY [LastName];
now I get this when I click the arrow

[June7]

Why are you enclosing quote marks in []? Brackets define a field or object.

Also, Access doesn't like slanted (”,”) marks. Should be ", "