Drop Down List

[Guest]

I have a form with a drop down list that shows employees by First and Last
Name. As of now when I choose an employee, I get only the First name. I
would like the form to show First and Last.

Thanks again!!!

 

[George Nicholson]

Comboboxes will only display the contents of a single field when "at rest",
but you can use a query to create a new field that includes the data from
multiple fields.

- Create a query that combines First & Last name in one Field:
FullName: [FirstName] & " " & [LastName]
You should also include the LastName, FirstName field as separate fields to
get the sort order correct.

- Use that query to feed your combobox, displaying the FullName field (the
first column/field with corresponding ColumnWidth > 0 is what will display).

HTH,