VB6 - Changing caption of a group of command buttons when clicking on Back or Next

Friends,
This code is related to command buttons.
I had posted this code for answering another thread(http://www.vbforums.com/showthread.php?t=536303) and I thought this will be helpful in somewhat to others. So, I am posting it in here.

If you have developed software for a hotel and you want to display name of 12 food items in 6 command buttons, then you can use my technique(just saying an example:))
It will help you to change the caption of command buttons on pressing Back button and Next button.

Suppose, you have 12 food items, say, a,b,c,d,e,f,g,h,i,j,k,l.
In the begining, the command buttons will display first 6 items. That is,
a,b,c,d,e,f. If you click the next button, then the rest of the items will be visible in the same command buttons replacing the old. If you press the back button, then it will display the first six...:) That's the method...

I had made two versions... One using the captions stored in an array, and the other from the database.

Array version of this code:
http://www.vbforums.com/attachment.p...8&d=1219291498

And the database version is in here:
http://www.vbforums.com/attachment.p...7&d=1219204013

------
I hope this will help somebody in someway..:rolleyes:
Please note that, I am not an expert. So, others may have even better ideas than me...:D

Also, please post your comments and suggestions...:wave:

-Best wishes
Akhilesh B Chandran