Ok, here is what I was planning maybe you have a better suggestion on how to
do this or actually how to do it.
I have a combo box which I wanted to use to pull up the persons last name
and first name in alphabetical order by last name.
The reason I wanted to make a new field with the person last then first name
is that when the combo button is clicked it would show both.
How do I get the combo button to show both last and first name without
creating a new field. I am going to use this to search the DB for their
record by last name and display it.
Rick B said:
You don't. Why would you store the same data in there twice?
Proper database design would dictate that you never store multiple versions
of the same data in a table. Store the first and last name in the table,
then format it however you want in your forms, queries and reports.
If you will do some searches, you will see this same topic covered in these
newsgroups 100 times and each time, the MVPs and the experienced users say
the same thing.
Rick B
pokdbz said:
That is not what I was exactly looking for. How do I put the entered values
straight into the table.
:
I need to combine a persons Frist and Last name into one field.
My table is Patient_Registry
The fields are: FirstName, LastName, FullName
I would like the last name to be first so it would look like this
in
the
table:
Doe John
How would I go about doing this.
Use the following as the ControlSource of a TextBox.
=[LastName] & " " & [FirstName]
