[ajndede]

bear with me, I'm new to ASP. I have a form that is up and working. I need to change a field from a text box to a checkbox. When the checkbox is checked and the form is submitted I need the form to write to a database field named jnum the next sequential number in that colum. Can't use auto number because not every submission will need a number. Right now customers have to go back through all the records and find the last number to manually enter it into the form before they can submit it.

Thanks for the help
AJ

[traceMe]

if u could elaborate a little on what u want i have solution for it.
i have made checkboxes that are generated via a loop and gets the values then i have entered it in database.