Double Control for Names?

[dohernan via AccessMonster.com]

I have a Letters Form based off a Forms Form.

In the forms Form I have separate Last Name and First Name Fields.

In the Letters Form I just have one Name Field, formatted Last Name, First
Name.

Is there someway to pull the Last & First names from the original form into
that single Names Field?

Thanks,
D

 

[Klatuu]

Wrong way around.
Always carry your names as separate fields. It is impossible to break them
apart with 100% accuracy, but it is very easy to combine them into one for
display purposes.

 

[Douglas J. Steele]

Create a query that has a computed field by typing the following into an
empty cell on the Fields row:

FullName: [First Name] & " " & [Last Name]

 

[John W. Vinson]

I have a Letters Form based off a Forms Form.

In the forms Form I have separate Last Name and First Name Fields.

In the Letters Form I just have one Name Field, formatted Last Name, First
Name.

Is there someway to pull the Last & First names from the original form into
that single Names Field?

Thanks,
D

STOP.

You're making at least two very common mistakes!

First off, forms are *nothing but windows*. Data is not stored in Forms; data
is stored in Tables, and only in Tables, and a form is just a tool to let you
manage data in tables.

Secondly, you're evidently storing data redundantly - the same name stored in
two different places. Relational databases use the "Grandmother's Pantry
Principle" - "A place - ONE place! - for everything, everything in its place".
The name should be stored, once and once only, in a Names table; it should be
stored in two fields, FirstName and LastName (it's best to avoid blanks or
special characters in fieldnames). They can easily be concatenated for display
purposes in either a Query or in the control source of a textbox on a Form or
Report:

[LastName] & ", " & [FirstName]

 

[dohernan via AccessMonster.com]

I got this working like so-

=Forms!Personnel2009Form!LastName & ", " & Forms!Personnel2009Form!FirstName

No more inbetween Form, just the Input Form and the Report/Letter.
I have only 1 main data table, and some dropdown list ones.

I have a Letters Form based off a Forms Form.

[quoted text clipped - 8 lines]

Thanks,
D

STOP.

You're making at least two very common mistakes!

First off, forms are *nothing but windows*. Data is not stored in Forms; data
is stored in Tables, and only in Tables, and a form is just a tool to let you
manage data in tables.

 

[John W. Vinson]

I got this working like so-

=Forms!Personnel2009Form!LastName & ", " & Forms!Personnel2009Form!FirstName

No more inbetween Form, just the Input Form and the Report/Letter.
I have only 1 main data table, and some dropdown list ones.

Again:

*You are misusing Access*.

If your only purpose is to print a report, you would do better to do so in
Word or Publisher.

Your Personnel2009Form is NOT a storage location for data. The Report will
print whatever the user types into the form, which will not be stored
anywhere.

The Report should be based, not on a Form, but on a Query based on a Table.
The last name and first name should be stored *in a table*, and the query will
link it to whatever other data needs to be printed.

Up to you but... you're misusing Access.

 

[dohernan via AccessMonster.com]

Whatever is typed in the Personnel2009Form IS stored in a table, which holds
names etc.
The Reports/Letters however are not stored.

Creating a query gives me an idea though. I want to start another table that
holds addresses, linked by the socials, so that I can create a specific type
of letter/report that Is stored.