two textboxes in form to one cell in table

[wickidwe]

I have a form to input info into a table
how can I combine 2 txtboxes to one column separated by ", "

Example:

textboxes:
txtboxFirstName txtboxLastName

output:

Last, First
into the "Name" Field in my table

 

[bob fitz]

IMHO it would be much better to save the data to independent fields. One for first name and one for last name. BTY as "name" is a reserved work in Access it would be a poor choice as a field name.