Can anyone help?

I have a form with multiple asp pages. The first page is an input page where you enter name, department etc. You then select click a hyperlink to another page where you input scores in text boxes.
I want to be able to submit all the data from both pages into one record in an access database.

I have no problem submitting data to access. The problem is retaining the data on the second page when you click back and go back to the previous page and then click the submit button to submit all the data entered on both pages.

I am a novice to asp and vbscript.
Does anyone know a script that can be used to accomplish this??

Would be greatly appreciated.

Jayman

Hii jayman!!
either
1>you can go for nested form work fine for IE.
but not in Other Browser plz refer. http://www.scss.com.au/family/andrew...s/nestedforms/
2>or using hidden form fields and javascript you can post all the data into start page ,then transfer the resulting page.
e.g , firstpage.asp contains all the forms.
    use javascript to hold all the form fields into separate/single form fields/field and change the behaviour of all the form submit button so that a click on any of the form post ,all the data into process.asp page from where user transfer method to subsequet asp pages that will process their relevant data.

Hope this will help you


Cheers :)

vinod

;;;I have a form with multiple asp pages

I assume you have multiple pages each with a form on them?

;;;I want to be able to submit all the data from both pages into one record in an access database.

I am not trying to change your design plan however placing all this information on the one page will eliminate your 'clicking back button' problem - Is this an option?

;;;The problem is retaining the data on the second page when you click back and go back to the previous page and then click the submit button to submit all the data entered on both pages.

This is not possible. If the second form is not submitted its values can not be carried back to the first page. Doesnt your first page form submit to the second page? If they click back from the second page, change details (on the first page) and click submit, they will end up back at the second page? So your problem is:
If this happens you loose the values on the second page??

IMO try no to use a browser dependent solution - There are other ways. Depending on your answer to my questions I would be tempted to use a temporary table to store information entered in each step. Then if the user bugs out before the end, remove the info from the temp table else activate it.


Wind is your friend
Matt

Hi Matt,

Thanks for your quick repsonse.

My problem is that the first page has hyperlinks to all the other pages. To use the form you enter name, department,etc on the first page. then click a hyperlink to another page to fill out scores for an application e.g MS word for Beginners.

You are right each page is it's own form.

Then if you decide you need to fill out another form on another page say MS Excel for Intermediate. you need to go back to the first page to click a hyperlink to get there. Basically the first page is not supposed to submit to the second page or any other pages.

Someone said suggested using hidden fields or querystring with a loop.But as i am a novice to asp and vbscript i havent got a clue how to do this? I normally work on examples of script and work my way from there ;)

Jayman

I wont sit here and knock the design process of your pages however I would do things different. Have you thought of a intuative step 1, step 2, step 3.... process? Anyhow Im not here to write code for people either - assist those with specific problematic pieces of code, yes.

Any way this may help you. You can use JS to make any hyperlink submit a form and or hidden form fields but you can not disable the back button in the browser (some may say you can. I have never seen it working accross the common browsers/versions)

<a href="#" title="Click to..." onClick="javascript:formName.submit();">Link Txt </a>

You can replace:
onClick="javascript:formName.submit();">
With:
onClick="someName();">
and re assign the action property to submit to different pages depending what link is clicked:

function someName()
{
   formName.action = 'pageName.asp';
   formname.submit();
}

Wind is your friend
Matt

I decided to put all the pages together in one page form and create an anchor link to each part of the page. So it looks like each part of the form is part of a separate page.
When the user clicks on an anchor link it takes them to a specific part of the page that looks like a whole new separate page.
This way you can submit from any part of the one page form and get multiple results in the access database.

Thanks for your help anyway.

Jayman