A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Drop down list- display and store last & first name



 
 
Thread Tools Display Modes
  #1  
Old August 24th, 2004, 07:51 PM
external usenet poster
 
Posts: n/a
Default 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  
Old August 24th, 2004, 08:09 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 10:54 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.