If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to make drop box that displays values (first & last names)
i have made the drop box, i hit the arrow and i get the list i want. The
problem is once i select it only shows one colum not both. Like a name field with first and last names. thank you |
#2
|
|||
|
|||
"josepe" wrote in message
i have made the drop box, i hit the arrow and i get the list i want. The problem is once i select it only shows one colum not both. Like a name field with first and last names. Set the RowSource of the combo box to a query that combines the names into a single calculated field. The SQL for such a query might look something like this: SELECT ID, LastName & ", " & FirstName As Fullname FROM MyTable ORDER BY LastName, FirstName; That returns two columns, an ID column (presumably MyTable's primary key) and a text column containing "LastName, FirstName". You would probably use the ID column as the bound column of the combo box, but the hide that column (by setting its width to 0) and show the FullName column. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down lists are displaying end of list, how to make it top? | LynnSouthan | Worksheet Functions | 3 | June 22nd, 2005 08:52 PM |
How can I make a drop down menu to navigate in a PowerPoint kiosk. | GreenbuildR | Powerpoint | 11 | January 12th, 2005 04:15 PM |
Make Word displays strings of text, not strings of code | Xero | General Discussion | 2 | December 9th, 2004 10:35 AM |