Concatenate two fields 1

[ramnewbietoaccess]

I have two fields on my form which i would like to concatenate in a separate field.

Ex:

Store Number Product Code Concatenate
102 AAAA 102AAAA


The Product code automatically populates in the concatenate field. How can i make the field insert the store number so that it appears in the field before the product code?

I hope I explained this clearly enough. THank you in advance for help.

 

[ZmrAbdulla]

Use

Me.Concatenate.Value= Me.StoreNumber.Value & Me.ProductCode.Value

OnEnter Event of Concatenate


Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[ramnewbietoaccess]

Thank you!

 

[markdfink]

Hi,

I just tried the following command:

Me.Concatenate.Value = Me.ImageName.Value & '_t.jpg'

and got a "Compile error: Method or data member not found". I am trying to populate a field called ThumbnailImage with the contents of "ImageName" that shows up earlier in the form, following that with "_t.jpg". Basically what I want to do is create an automatic name for a thumbnail of an image based on the ImageName field. I'm putting this in the "On Enter" section.

Thanks,

Mark

 

[bernie10]

Concatenate" was the name of ramnewbietoaccess's field.

From what you've said it sounds like you need:

Me.ThumbnailImage.Value = Me.ImageName.Value & "_t.jpg"

HTH,
Collen

 

[markdfink]

Collen,

Thanks - that was perfect! Now I understand better what is happening.

Mark