Insert two data sets into one table cell

[hrg]

I have this line of code and i want both of them to be present in that single field

line of code

Key = Forms!frmorder!Text21 & Text23

The

key = a column name in a table

frmorder = the form

text21 = name field
text23 = address field

text 21,23 are both text fields.

I want to be able to put both sets of data into one cell in my table with my code but my line of code will only show the name and discards the other or it just comes up with an error.

how can i write it so that it lets me put both sets of data into one cell in the table (i.e. in my case key)

 

[THoey]

How about:

Key = Forms!frmorder!Text21 & Forms!frmorder!Text23

Terry M. Hoey