I need to rebuild the sub-form and see how it now works..
Are the old case numbers you refer to above in the same format as your example (C11-123)? Yes, and stored for a future look-up table.
Do you need to reset the sequential number at 1 at the start of each new year? Yes, I am looking at a way to automate that as well.
Wayne