I have an ID number as ABCD-1234-123.
I use an Excel UI to add data to Access table.
The ID is division (alpha), department (four digits in the middle) and the
last three digits are sequence.
When I update this record, I actually want to add a new row to the table and
increment the sequence for each update.
So the initial record is ABCD-1234-001.
First update will be ABCD-1234-002.
Second update will be ABCD-1234-003 and so on.
Can some one please help with making sure that I keep the leading zeros.
Riight now, I cannot seem to do it.

Thanks.