Autofill text field using rowsource+date

[srcacuser]

Hello,

I'm trying to autofill a field on a form.

The form has an existing text field called PROJ, using the row sources "ABCD", "EFGH", "IJKL".

A user begins filling out the form and eventually selects the PROJ.

There is another text field, which is actually alpha-numeric, called FORM_NUMBER. I want this to autofill based on thier PROJ selection, using this format:

ABCDYYMMDDTTTT, or ABCD1111300915 for example, for today with the time displayed as military time.

Any suggestions?



Thanks in advance

[Toyman]

Hello,

I'm trying to autofill a field on a form.

The form has an existing text field called PROJ, using the row sources "ABCD", "EFGH", "IJKL".

A user begins filling out the form and eventually selects the PROJ.

There is another text field, which is actually alpha-numeric, called FORM_NUMBER. I want this to autofill based on thier PROJ selection, using this format:

ABCDYYMMDDTTTT, or ABCD1111300915 for example, for today with the time displayed as military time.

Any suggestions?

Thanks in advance

In the after update event for PROJ, put in the following code:

Me.Form_Number = Me.PROJ & Format(Now,"yymmddhhnn")

[srcacuser]

Toyman,
You made my day. I thank you, sir.