user name format

  • Thread starter Thread starter Lauren B
  • Start date Start date
L

Lauren B

How can I take three separte fields, LAST NAME, FIRST NAME, and MI, and have
them appear in a drop down menu as one term Last Name, First Name, Middle
Initial.

The purpose of this drop down is to run a query on that individual.

Thank you in advance for any assistance.

LB
 
You can create a query to put the name fields together, something like this
(watch out for line-wrapping) and assume your table name is "tblPeople" and
there's a primary key field called "RecordID":

Select [RecordID], [Last Name] & ", " & [First Name] & " " & [MI] As
Name, From tblPeople;

This will create a row source for your combo box that will give you the
record id and the name formatted as [Lastname, Firstname MI]. If you hide
the first column in your combo box, your users will see just the name in the
dropdown list.
 
Back
Top