can you combine columns on a combo box?

  • Thread starter Thread starter Tmarkos
  • Start date Start date
T

Tmarkos

I have a combo box that is three column. The ID number, Last Name, First
Name with the number width set to 0. It records the id number in the table.
When you start typing the last name it populates the list of clients. Can
you combine columns in within the combo box so you can type the last and fist
name then choose from the list?

ie if you have 50 smith's can you set it up to type smith, jane
 
Tmarkos,
Just concatenate the Last and First in the query behind the combo.
Ex...
FullName : LastName & ", " & FirstName
Now the combo will be 2 cols.. ID and FullName
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top