Inputing data from form textbox to table field.

[Tinius Olsen]

Example:
Form "frmNames" from table "tblName" which has three
fields per record:
1) [First]
2) [Last]
3) [Concatenated]

Form has fields to input the first name and last name into
the table. It also has Text box with following Control
Source:
[First]+" "+[Last]

Need to input this concatenated text from text box into
Field [Concatenated] of same record.

Is this possible and how?

TIA for answer.

 

[Rick Brandt]

Example:
Form "frmNames" from table "tblName" which has three
fields per record:
1) [First]
2) [Last]
3) [Concatenated]

Form has fields to input the first name and last name into
the table. It also has Text box with following Control
Source:
[First]+" "+[Last]

Need to input this concatenated text from text box into
Field [Concatenated] of same record.

It's possible, but it would be incorrect and unnecessary. Any place you need the
concatenated value you should just use an expression to do it on-the-fly. I would
recommend eliminating this field from your table and then creating a query that
includes the first two fields and then adds an expression for the third field. Then
you only need to write the expression once and you simply use the query every place
you would otherwise have used the table.

Concatenated: [First] & " " & [Last]

BTW I would also change those field names to FirstName and LastName since the words
First and Last are the names of functions in Access and could cause you problems.