Concatenation Question

  • Thread starter Thread starter Dave Kennedy
  • Start date Start date
D

Dave Kennedy

I have a form in which users fill in three fields as part of the form. After
this is done I want them to be able to click a button and have the data in
those three fields combined with the primary key and this concayenated data
to be loaded into another field on the form? How would I do this? Thanks for
your help.
 
I can't imagine why you would do such a thing. Each data item should stand
alone. To repeat data in a table is not good design. It would be better to
concatenate them when you intent to use them for some other purpose. I
suggest you rethink your design. But, with that said, the way to do it would
be in the Click event of the button.

With Me
.ConcatControl = Nz(.SomeControl,vbNullString) &
Nz(.AnotherControl,vbNullString) & Nz(.AnyControControl,vbNullString)
 
Back
Top