Hello,

I may have asked this in the visitor forum.

I want to have a unique record number that showns up on each form i want it to be, YYYY, mm, dd, sequential number so 2025-09-13-0001, can i get this to work in auto number with the correct format, i was thinking if not maybe have a seperate text box for the month, day and year, if i could have each box to show correctly and change as the date changes with some VBA code, i can then have the sequential number be an autonumber.

My only problem with this is that it would be hard to search for the record this way.

Any thoughts on the best way to accomplish this?

Thanks