Replicating Information (1 Viewer)

[MartinC]

I would like to take an invoice number from one control on a form after a user enters it and use it as the beginning string in a text box or memo field and have the concatenated fields saved in my table. Does anyone have any suggestions? I would appreciate any ideas. Thanks.

 

[bob fitz]

I'm not sure that it's a good idea to save the joined data to a table.
I think it would be better to use an expression like:
=[InvNum] & " " & [Memo]
when and wherever it is needed.

 

[pr2-eugin]

As mentioned by Bob there is absolute no need to save this information.. As saving it to another field will only add up memory to your table.. So to display it in reports/queries/forms just use the method shown above..