generating values from a number range

[lkuch]

How can I generate values from a number range like 780-799 and include alphabet letters and cycle thru all the alphabet letters as well. ex. 780, 780a, 780b, 780c...799a, 799b, 799c and so on and start over again...780aa, 780ab, 780ac...799aa, 799ab, 799ac and so on. All to auto populate a text box. Is there code that can do this?
Any help would be appreciated!

 

[Kherozen]

Can you introduce a context? and what do you mean by " to auto populate a text box"?

 

[lkuch]

Well, I would like to auto populate a text box on my form. The textbox would be used as part of a document number. Right now my document number format is one textbox bound to a Req table, giving me a Req number - 03RQ. The next textbox is a julian date field auto populated and converted from a date field and I will need this new textbox to generate and auto populate the textbox from the number range. ex.(03RQ-3169-780a). Could you elaborate about introducing a context.
Thanks!

Lou