Hi

(Question) I have a table with 1 column called "Names". Can I design a form which has 2 text boxes which both relate to the "Names" column.

So...one text box is called Name1 and the 2nd is called Name2. I want both of these text boxes to write to the column "Names".

Can I do this and if so how?

Thank you in advance

Ruby

I'm assuming that you want a first and last name to be in the two textboxes and the single box to have the two concatenated together... If so, you can just set the control source of the single text box(Names) to

=[Name1] & " " & [Name2]

This will populate when you enter data... Hope this helps.

Doug

Ruby, do not store multiple values in the same column. Create a second column in the table. Separate fields will be much easier to work with in the long run.

The solution suggested by D=Fresh is incomplete. It is not quite that simple to mush fields together (at least if you want to separate them later) plus, you also need to separate the data in the onCurrent event of the form to display data from the existing records since you would have had to use unbound textboxes to implement D-Fresh's suggestion.