By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,191 Members | 1,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,191 IT Pros & Developers. It's quick & easy.

Displaying Full Name in drop down box from First Name & Last Name columns?

P: 1
Hi, Just playing with Access fairly new to it (like days old). Also it's my first post here so if I'm in the wrong place, sorry..

What I'm wanting to know is basically I have lets call it Table Data and I've got Last Name, First Name in the columns. I than have Table Full Name, with column Full Name. I have a relationship between the primary key of Table Data and the column Full Name. I have a form that displays the Full Name column. Its in a drop down list but I can only get Last Name to appear. I want to be able to have Last Name & First Name to appear as two people may have the same last name. How do I do this? I'm a complete beginner at this and my database has been simplified to try to get what I'm trying to achieve across.

I've googled and found stuff about concatenating but yet to get it going. I figure there has got to be a relationship in order for me to the data combined in the drop down box but I could be waaaay wrong.

Thanks.

EDIT: By columns I think I mean fields?
Mar 12 '08 #1
Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
Table Full Name is not needed. If you have a query based on Table Data go intoit in Design View. If you don't, you need to go into Design View for Queries and create a query with all the data from Table Data. Now go to a blank field in the query grid and type this in:

FullName: [LastName] & " " & [FirstName]

Now go into Design View for your form and replace the table in the RecordSource with your query. Delete your old combobox and create a new one. This time, when the Wizard comes up and asks for the table or query to retrieve the data from, select your new query. Next choose FullName as the field for your combobox.

That should do it.

Welcome to TheScripts!

Linq ;0)>
Mar 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.