I've been asked to created a program for my local video rental shop, that can store the details of the members, videos, dvds etc. On the for were the user adds a member, I am wanting some code that will generate the membership number automaticaly in a edit box. E.g. the firs member would have the membership number "0001", when I add another the membership number would be "0002". Other words the membership number goes up by one each time.

Could someone please help me.

easiest solution would be to find the count of the number of members currently listed, add 1 when new user is created, then use the format command to format the string with leading zero's

if you need some code let me know and i'll try to get something knocked up

Thank you. i mostly likely will later on.