I have set up a basic table on Access. Ist field is the primary key ID field which automatically increments which I don't want to touch.
I have a field called OpenDate and another called UFN.
I have created a form with these three fields with the form named as frmOpenFile.
What I need is code to be entered on the AfterUpdate event in the textbox [OpenDate] to convert the format from e.g. 01/02/2019 to 010219 and auto insert that in to the UFN box with an increment of three digits at the end to give the unique Id.therefore when you select a date opened the UFN box is autopopulated with the next unused UFN. Therefore if u select 1st Feb the UFN box should autopopulate with 010219/001.
If I open a new record and insert the same date the UFN should be 010219/002 and so on.
Thanks