As far as simply sequencing, I would insert a Seq Field where you want the numbering to appear and then update the field in the table.



However, for your basic question how is your macro supposed to know when the next number should be 3 or 3a? Or how long that sub-sequence should run before 3d becomes 4?

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/