Setting a default value in a drop-down list

[smile4u]

Hello! I have a drop-down list that when a person's first name is selected then it will fill in the person's middle and last name. Is it possible to use a name that is frequently used as the default so that it is always filled in on the form? More specifically, how will it work so that the other fields (middle name and last name) will also be filled in with the default first name? Or is this not possible to do?
Thank you in advance!

 

[MarkK]

It seems to me that a list from which you select a first name, that automatically fills in a known middle and last name, is a sort of waste of time. The outcome is that you select a known name. I would give a user the capacity to select this known name in one shot rather than a system where they select a first name, and a likely middle and last are suggested, and then a mechanism is required to change that also, if it wasn't the right middle and last name. Maybe I misunderstand what you propose, but the process seems laborious.

Also, in respect to the question, "is it possible?" The answer is yes almost 99.9% of the time, so as a question, it is of dubious value. Better to describe your skills, then ask if a problem would be difficult for you, and where you should start to learn more.

Hope this helps, and welcome to the forum,

 

[smile4u]

Thank you for your response, MarkK.
I am still a beginner with using Access.
I agree that they way that I have set up the name is quite laborious. How would you propose to do it in one shot? If it can be done in one shot, then can the first, middle, and last name be in separate fields in the table?
Again, thank you for your help!

 

[MarkK]

Yeah, you can write SQL for a combo that looks like . . .

SELECT PersonID, FirstName + " " & MiddleName + " " & LastName As Fullname
FROM tblPerson
ORDER BY Lastname, Firstname, MiddleName

. . . so the names remain separate in the table.

 

[smile4u]

Thank you! I think I got it.