Autofill field based on autonumber field

[frevilla]

Hello

I have an add-only form that has an autonumber field. This autonumber gets a new number once you fill any other field on the form.


I need to have on the same form an autofill field that has the autonumber included on it, besides other data from the same form.
This autofill field should be stored on a table.

Let's say
1. Opened Form
2. Autonumber populated once I type on any field (ie 5623)
3. Autofill field empty but once ?I click on it? I get this:
DCA/TX-09-5623 (This field should be stored on a table)
where:
'DCA/TX' is the department I work for (combo box on form)
'09' is the last two digits of the current year (date on form)
'5623' is the autonumber given by MS Access

The objective is to generate a code name on things that come to the departments based on Access autonumber feature.

Thank you in advance for your help!

[SoftwareMatters]

You need to concatenate the various fields. I would do this in a public function behind the form and then call it on the AfterUpdate of each field and OnCurrent of the form. The code would be something like this:

Me!AutofillField = Me!DepartmentField & "-" & Right(DatePart("yyyy", Me!DateField), 2) & "-" & Me!AuotnumberField