can you combine columns on a combo box?

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
 
A

Al Campagna

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Searching within a combo box by any column 1
Auto Populate a Combo Box based on the user selection of another Combo Box 4
auto populate text box based on combo box value 1
COmbo Box with text box 1
filter on combo box possible? 1
Trouble Filtering a Sub Form With Combo Box Options 2
Find a Record Based on Combo Box 13

Top