Query results and Update Query In forms

[Klutzz]

I have a frontpage2003/Access database on an intranet with ASP working fine.
My database table has 20 fields total.
I need to enter data in steps or parts.
The first form imputs the first 5 fields and then submits.
On the second form I need to redisplay the data entered on the first form
and and the next 5 fields that now require imput.
I have a page that displays a list of ONLY the recordsets requiring imput of
the second set of data. Following a hyperlink in the results "ID" col. takes
the user to a page that displays the previously entered data as well as the
data to be entered for section 2.
All of this seems to be working as expected.
The problem starts when I try to use an update query to update the recordset.
I can figure out if my 2 db results areas (one to retrive the recorset and
the second to update it) should be nested inside of each other or maintained
as distinct areas on the form.
My update query is validating fine within the wizard but creats a new
recordset and in some cases is entering the old and new values in the same
dbase field in my table.
I looked at using the query in the first results area but it appears that
tha will cause a problem in obtaing the values to be displayed.
If I am using 2 seperate dbase results areas then how do I get the "Key"
value passed to the second results area ???


Any help is highly appreciated !!
Thanx in advance for any suggestions.

Klutzz

 

[p c]

Is not using the FP wizard an option for you? You coudl write your win
code in ASP to do thing the way YOU want them.

If all the 20 fields are for the same record, is retrieving them and
updating them all at the same time an option for you.

You can still upate them in phases, 5 fields at a tiem, but if the user
does not go through all phases, the record will only be updated
partially. Is this OK?

...PC