get the max of the field into a variable, add one to it to get the 

starting loop. Then you can loop five time to build the options lines, 

attach the select header and footer. Voila! you have the dropdown.



Anoop

> Hi everyone,

> 

> Here's what I need to do.  

> 

> Say I have five records in a database which has a field that has a 

> value of "1" for the first record, "2" for the second, etc.

> 

> What I want to do is if the last value is "5", I want to populate a 

> dropdown box  on a form with values of say "6" to "10".

> 

> these values don't need to come from the db. I just need to populate 

> the dropdown box with these values.

> 

> thanks,

> jeff scott

> 

> Jeff Scott

> Email: jeff@j...

>