Using combo boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a new user. I have created a form to enter data in a table. Using a
combo box, I can locate an individual by first name and last name (stored in
two different fields of a table), and the correct data is inserted in the
correct field of the correct table when make my selection, but after I make
the choice only the first name is displayed in the combo box. The results may
be and usually are correct, but as I scan the form I cannot be sure the
correct "Bob" or "Fred" was actually selected when the drop-down list was
visible. How can I correct this?
 
I am a new user. I have created a form to enter data in a table. Using a
combo box, I can locate an individual by first name and last name (stored in
two different fields of a table), and the correct data is inserted in the
correct field of the correct table when make my selection, but after I make
the choice only the first name is displayed in the combo box. The results may
be and usually are correct, but as I scan the form I cannot be sure the
correct "Bob" or "Fred" was actually selected when the drop-down list was
visible. How can I correct this?
Click to expand...

As Rowsource for the combo box, try something like this:

Select TableName.Id, LastName & ", " & FirstName as FullName From
TableName Order By [LastName] & ", " & FirstName;

Set the Bound Column to 1
Set Column Count to 2
Set the Column Widths to 0";1.5"
Set AutoExpand to Yes

Using the above, the ID will be hidden, and the full name will appear
(last name first) in the combo box. When you select the correct
person, the ID will be stored in your table.

I've used last name first to facilitate finding the correct person,
there may be hundreds of Johns, but only a few Smiths.

Note: You might wish to add additional fields to the combo box, so
that in the event there are two or more "John Smiths", you can select
the correct one.
 
Back
Top