Concatenation in Form

[theleebaldwin]

I am creating a form that users will use to input a style number and color number for a particular product. I want to concatenate these items together with a hyphen in between them. What would be the best practice way to do this? I currently have the following in the Default Value on the Data tab: =[txtStyleCode] & "-" & [txtColorCode]. Will this achieve the desired result and align with best database practices?

[pbaldy]

That won't likely save the value, if that's what you're after. I'd simply display it with that in the control source; we don't typically save calculated values. There is a new calculated field data type, so that may be a solution too.

[theleebaldwin]

Thanks pb. I want to save this calculated value as I am going to use it as my primary key and relate it to a field in a UPC table. I am assuming (newbie here) that I can use a submit button and run a query that will take my information and save it into my table including this calculated field. Am I on the right path to success?

[June7]

Saving the value from a form bound to the table can simply be:

Me!fieldname = Me.textboxname

The real trick is figuring out what event to put this code into. Try the form BeforeUpdate event.

[theleebaldwin]

Thanks June7. It will be a few more days to get to the point where I can try this so I will close the thread and if need be I will reopen it.

Lee