Storing a combined form value to a table field

[petehk]

Hi, I am trying to create a value on a form and then write it to a table field. ie. the user inputs first name and last name in two bound fields on a form. This then creates a users full name in a third bound field in the format surname, forename using a control source =[surname] & ", " & [forename]. However I then need to take this and store it into a third field in the relevant table. I know its going to be a simple answer, but i can't quite seem to lay my hands on it.

Thanks

 

[llkhoutx]

Me!ConcantenatedFieldName =[surname] & ", " & [forename]

ConcantenatedFieldName is a valid bound field on your form

 

[Rich]

Why would you want to store the concantenated value?

 

[petehk]

Have a purchase order system where users are added to the system using one form by inputting separate forename and surname and then selected via combo box on the main form which is displayed as a concantenated (thanks for the right word) value. I then need to use this value in generation of the physical purchase order and a subsequent authorisation form. Will try the below suggestion and come bakc to you. Thanks.

 

[maxmangion]

you shouldn't store calculated fields in your table. If you would like to use such a field in your purchase orders, create the calculated field in a query, and then base your purchase orders on that query.