Dreamweaver MX 2004 ASP Visual Basic

An Html form passes a variable to a data update form.

The records which are pulled up are correct. You can page through the records and the form parameter is passed. However, when you enter data and select the update records button, the data is updated but it goes to the first record in the database – the form parameter is not passed. However if when entering the update form, I select the Next record link and then go back to the first record, the form parameter is passed and I can navigate to and update all the records. I believe the problem is in the redirection page parameters in the update form. Right now it is going back to the update form page without any parameters. I dont know what the parameter should look like. When the parameter is passed it looks like this:

UpdateProfStudiesKnowledge2.asp?optref=10310&Submit=Submit&index=0

10310 is the form variable which is being passed - named varref, the Access field name is Refno.

I would also like the update records button to go to the next record automatically. The user has to enter data, click on update, then click the next record button. I would like the user to click on update and it automatically goes to the next record.

I just changed post to get and it works fine now. The parameter gets passed