Name field that combines FirstN, MI, LastN

  • Thread starter Thread starter Fred Worthington
  • Start date Start date
F

Fred Worthington

Greetings:

I have a directory of clients with separate fields for FirstN, MI and LastN.
I would like to have an additional field display the full name, Last Name
first (so they can be sorted alphabetically). Additionally, I want the
"full name" field to be a combo box (probably using a query for its record
source) that will record the name in a Table (so it can be used in a
Report). I have used:

=Forms![Client Form]!FirstN & " " & [MI] & " " & [LastN]

but this method of placing the full name in a Form field only shows up in
the Form, and doesn't record the name in a Table. Any suggestions?

Thanks . . . Fred
 
Greetings:

I have a directory of clients with separate fields for FirstN, MI and LastN.
I would like to have an additional field display the full name, Last Name
first (so they can be sorted alphabetically). Additionally, I want the
"full name" field to be a combo box (probably using a query for its record
source) that will record the name in a Table (so it can be used in a
Report). I have used:

=Forms![Client Form]!FirstN & " " & [MI] & " " & [LastN]

but this method of placing the full name in a Form field only shows up in
the Form, and doesn't record the name in a Table. Any suggestions?

Thanks . . . Fred
Click to expand...
Don't store it in the Table
also in Report concertanate this fields with the same formular

If you store it and change on field the stored field will be outdated
 
I agree that you should not store the name. A table is not a spreadsheet,
even though it looks like one. Concatenate on the report as suggested, or if
the report's record source is a query you can create a calculated
(concatenated) field there (FullName: [First] & " " ... etc.). On the
report, set the text box's row source to LastName.
On the form you can place a combo box with a SQL statement including
ClientID, Last, & [FullName] (constructed as outlined previously) as the row
source (click Row Source on the combo box's property sheet, click the three
dots, and build it just like a query). In the query design grid sort by last
name. Set the column count to 3, the first two columns' widths to 0 (and the
third to 1.5" or so), and the bound column to 1 (the primary key field). You
will be storing the client's primary key (as you should), sorting by last
name, and viewing full name. You could also use the form's record source
query as the row source for the combo box, but I prefer to keep them
separate, just because there is less chance of a design change resulting in
combo box strangeness. In either case the control source will be the
ClientID field.
 
Thanks. That's what I needed to know.

Fred


BruceM said:
I agree that you should not store the name. A table is not a spreadsheet,
even though it looks like one. Concatenate on the report as suggested, or if
the report's record source is a query you can create a calculated
(concatenated) field there (FullName: [First] & " " ... etc.). On the
report, set the text box's row source to LastName.
On the form you can place a combo box with a SQL statement including
ClientID, Last, & [FullName] (constructed as outlined previously) as the row
source (click Row Source on the combo box's property sheet, click the three
dots, and build it just like a query). In the query design grid sort by last
name. Set the column count to 3, the first two columns' widths to 0 (and the
third to 1.5" or so), and the bound column to 1 (the primary key field). You
will be storing the client's primary key (as you should), sorting by last
name, and viewing full name. You could also use the form's record source
query as the row source for the combo box, but I prefer to keep them
separate, just because there is less chance of a design change resulting in
combo box strangeness. In either case the control source will be the
ClientID field.

Fred Worthington said:
Greetings:

I have a directory of clients with separate fields for FirstN, MI and LastN.
I would like to have an additional field display the full name, Last Name
first (so they can be sorted alphabetically). Additionally, I want the
"full name" field to be a combo box (probably using a query for its record
source) that will record the name in a Table (so it can be used in a
Report). I have used:

=Forms![Client Form]!FirstN & " " & [MI] & " " & [LastN]

but this method of placing the full name in a Form field only shows up in
the Form, and doesn't record the name in a Table. Any suggestions?

Thanks . . . Fred
Click to expand...
Click to expand...
 
Thanks. You set me in the right direction. I now have my name field set up
the way I want it.

Fred

Andi Mayer said:
Greetings:

I have a directory of clients with separate fields for FirstN, MI and LastN.
I would like to have an additional field display the full name, Last Name
first (so they can be sorted alphabetically). Additionally, I want the
"full name" field to be a combo box (probably using a query for its record
source) that will record the name in a Table (so it can be used in a
Report). I have used:

=Forms![Client Form]!FirstN & " " & [MI] & " " & [LastN]

but this method of placing the full name in a Form field only shows up in
the Form, and doesn't record the name in a Table. Any suggestions?

Thanks . . . Fred
Click to expand...
Don't store it in the Table
also in Report concertanate this fields with the same formular

If you store it and change on field the stored field will be outdated
Click to expand...
 
Back
Top