Combine the values of two fields on a form

[nyteowl]

I want to take the existing values in two fields on a short form and combine them to create a unique ID for each record.



The first field is a text field that contains an acronym representing a company, e.g., USPS. This value will be selected from a Combo Box.

The second field contains a date (Short Date format, 10/11/2010), which will not necessary be the current date.

I want to change the Date field into a yyyymmdd format, insert a period at the end, and then append the acronym field so I'll end up with something that looks like this:

20101011.USPS

The ultimate goal is for this to run as an On Exit Event Procedure after I enter the date and move on to the next field on my form.

Thanks in advance for the assist.

[pbaldy]

Along the lines of

Format(DateField, "yyyymmdd") & "." & TheTextField

[nyteowl]

Thanks much!!

[pbaldy]

Happy to help, and welcome to the site by the way!

[nyteowl]

Thanks again...