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
|
|||
|
|||
Drop down list- display and store last & first name
I have created a drop down list that displays the last
and first name a two different fields. when i select the name I would like it only stores and displays the last name. I would like it to display both the last and first name on the form. Please help?? How can i do this. Thanks, barb |
#2
|
|||
|
|||
What you want to do appears to not be a good idea.... fields should not
contain combined data because it's difficult to separate them back out. However, if you're just storing info for printing out, etc., then what you're doing may be ok. Use a query as the Row Source of the combo box: SELECT [FirstName] & " " & [LastName], [LastName], [FirstName] FROM TableName; Set the combo box's Bound Column to 1. Set the Column Count to 3. Set the Column Widths to 1";.0.5",0.5". This will show the combined names, last name, and first name in the dropdown list, and will display the combined name in the combo box after selecting. A combo box will display (when the dropdown list is not showing) only the first visible column. -- Ken Snell MS ACCESS MVP wrote in message ... I have created a drop down list that displays the last and first name a two different fields. when i select the name I would like it only stores and displays the last name. I would like it to display both the last and first name on the form. Please help?? How can i do this. Thanks, barb |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
change drop down list contents based upon value from another list | A P Cummings | General Discussion | 1 | August 2nd, 2004 08:16 PM |
Selecting a contact list | DianaH | General Discussion | 11 | June 22nd, 2004 02:26 AM |
Non display of inbox mail. | Bert | Outlook Express | 1 | June 12th, 2004 04:54 AM |
How to store calculated fields ? | Nico | Using Forms | 13 | June 7th, 2004 02:57 PM |