Just add the ID to the 2nd form as a hidden field
<input type="hidden" value="<%=FP_SavedFields.Item("ID")%>" name ="ID">
and read it on the 3rd page or form as a normal field
<%=Request.Form("ID")%>
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
| Continued Thanks for your assistance. I used the instructions in the
| autonumber article to capture the ID originally and it works when I'm only
| registering one player per family - my problem is when I register multiple
| players, one at at time, that I seem to loose this ID number. I'll try to
| explain my need more clearly:
|
| Registration Web that saves to Access DB. In Access, I have a tblFAMILY and
| a tblPLAYERS. The tblFAMILY has an autonumber ID field. One family can have
| one or mulitple players registered so I need the ID field from tblFAMILY to
| pass to each player registration so it too gets saved in the tblPLAYERS. on
| FORM1 the family info is entered and submitted to tblFamily - I used the
| insturctions iSpiderwebwoman/Travis to save the autonumberID field which
| successfully displays on the confirmation page, FORM2.asp. In addition to
| confirming the FAMIY info, FORM2 also includes a 2nd form where Player info
| is submitted to register a player. The Family ID is successfully passed
| along with this player registration to the tblPLAYERS and the user is taken
| to a CONFIRM.asp page where I once again display the FAMILY ID as a
| confirmation field and using <%=FP_SavedFields.Item("ID")%> - I put these in
| two separate forms - one provides the option to Complete the registration
| process and the 2nd asks if the user wants to register another player - the
| submit button on the register another player form saves the form to
| Custom...ASP Script and directs the user to FORM3 to register another player.
| On FORM3 I have the form to register another player and a field that
| requests <%FP_SavedFields.Item ("ID")%> but that field is now blank. I've
| lost the Family ID at this point - can you assist me in resolving what error
| I'm making that causes me to loose the Family ID???
|
| THANKS!
|
| "Stefan B Rusynko" wrote:
|
| > Your ID is an autonumber field
| > See
http://spiderwebwoman.com/thingumajig/tweaks.htm#autonumber
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Hello - Have been hacking away at this trying to find the answer....made some
| > | headway but still do not have it working as needed.
| > |
| > | To re-explain my set up and goal - I have a FP2002 web, Access 2002 DB.
| > | taking Registrations for sports team. FORM1 takes "family" info and submits
| > | to tblFamily in Access and brings user to Confirmation Page combined with
| > | FORM2. Confirmation page WAS a DBR but is now made up of confirmation fields
| > | - all of which seem to work including getting the autonumber "ID" field from
| > | the Family table. Below the confirmation section is FORM2 where parents can
| > | enter a PLAYER (child). The Family "ID" is submitted to the tblPlayer along
| > | with the player info just filled in by the parent. This all works. Submit
| > | from FORM2 takes the user to a .asp page where I have a form asking if the
| > | user wants to add anothert player (multiple children in one family signing up
| > | for the same sport). If they want to ADD another player, they should go back
| > | to the same FORM1 and submit another player and the loop continues until the
| > | parent selects COMPLETE REGISTRATION. Problem is getting the Family ID to
| > | show up on FORM1 for the 2nd, 3rd ... registrations. Seems this saved field
| > | is lost after I submit FORM2 which has the player info on it.
| > |
| > | I've tried so many different page scenarios trying to get this to
| > | work...there has to be a way to take registrations while keeping the same
| > | initial session variable=ID from the original form submit throughout the
| > | registration process. Can anyone direct me to the answer of how to
| > | accomplish this?
| > | I will be very grateful!
| > |
| > | "MaureenKLM" wrote:
| > |
| > | > Thanks for the help! Error I am getting is
| > | > Parameter ?_1 has no default value
| > | >
| > | > I have input ID EQUALS [ID] in the criteria of the DBRW, The Default Value
| > | > is ID [ID]. It certainly appears as if I'm doing something wrong with this
| > | > autonumber ID field being used as the criteria for a new DBR. If I put the
| > | > value in a form field and then SUBMIT the form, the DBR displays correctly -
| > | > but I want the DBR to just display without the user having to click on a
| > | > button - I want to callup the DBR using the saved autonumber field, ID in
| > | > this case, as the criteria. Is there a way to accomplish this?
| > | >
| > | > "Stefan B Rusynko" wrote:
| > | >
| > | > > What specific error are you actually getting
| > | > > To see the reall DBR errors, open the hidden folder /_fpclass/ and edit the fpdbrgn1.inc file
| > | > > At about line 19, change :
| > | > > fp_DEBUG = False
| > | > > to :
| > | > > fp_DEBUG = True
| > | > >
| > | > > Note: an autonumber file can not be treatef as a text field in you query - try using criteria ID = ID
| > | > >
| > | > > --
| > | > >
| > | > > _____________________________________________
| > | > > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > > "Warning - Using the F1 Key will not break anything!" (-;
| > | > > _____________________________________________
| > | > >
| > | > >
| > | > | > > | FP 2002 with Access 2002 DB -
| > | > > |
| > | > > | Registration web - Families register their children for local sports
| > | > > | activities. Form1 with the FAMILY info is submitted to Access DB, I capture
| > | > > | the autonumber "ID" field and use it on a confirmation page thanks to FP's
| > | > > | Confirmation Field. I then use this same ID value as a hidden field when a
| > | > > | 2nd form is submitted to a different table of the DB (Player info is
| > | > > | submitted on Form2 to a players table and the Family ID, created when Form1
| > | > > | was submitted, is correctly passed). All works -
| > | > > |
| > | > > | Problem I'm having is in trying to create a DBR region on a final
| > | > > | confirmation page - DBR gets FAMILY data from a table or query (I've tried
| > | > > | both). I want to pass the ID parameter to the DBR but it errors out when I
| > | > > | try to use the Confirmation ID field.
| > | > > |
| > | > > | I have the ID field correctly displayed on the page using the Confirmation
| > | > > | Field- I try to use this as the paramater criteria in a DBR which immediately
| > | > > | follows the ID field displayed. The DBR errors out. I've tried using the
| > | > > | WHERE clause in the Custom Query section of the DBR - and I've also tried
| > | > > | just setting the criteria ID = ::ID:: using a search form field. Nothing
| > | > > | works. What am I doing wrong here?
| > | > >
| > | > >
| > | > >
| >
| >
| >
