Multiform questionnaire overwrites first record

[Jason A. Thompson]

Dear Access Gurus,

I have a database which I hoped to use to administer questionnaires,
or rather that someone who knows nothing about Access could use to
administer them. Each q'aire item is on a different form and I dropped
in command buttons on each to move forward and backward through the
"pages" of the q'aire. Problem is, the first record in the common
underlying table is overwritten each time we go through the q'aire.
(The code to open the next form is accompanied by code to close the
previous -- originally I thought the problem was that multiple forms
were attempting to write to the same record.) On the first form, which
launches automatically via an autoexex macro, I assign some variables
via VBA code in a new record and this works correctly each time.
However the controls on subsequent forms seem to point to the first
record only. It feels like a "gotcha" kind of problem that many others
have probably solved but I haven't been able to find a solution in the
FAQs. I figure it has something to do with record navigation that must
be done within each form as it is opened, but have not been able to
get recordset.MoveLast to work, for instance. Assume for the purposes
of this question that I am stuck having to fix this database
application and that other well-known solutions for questionnaire
administration are not available.

Many thanks for info/pointers.

[Pieter Linden]

I would read Keri Hardwick's posts on creating a questionnaire in
Access. She knows her stuff and explains in good detail how to do it.
Search the NG for her name and "survey".

[Jason A. Thompson]

pi********@hotmail.com (Pieter Linden) wrote in message news:<bf**************************@posting.google. com>...

I would read Keri Hardwick's posts on creating a questionnaire in
Access. She knows her stuff and explains in good detail how to do it.
Search the NG for her name and "survey".

I have found no message in these threads addressing specifically my
question, although there is plenty of solid advice on other design
issues. Any other pointers come to mind? I'm so close and this seemed
such a simple problem. Obviously not!

Thanks in advance,

Jason

[DFS]

Jason,

You're probably doing some or all of these, but just in case:

* open your initial form in data entry mode, which will start a new record
* assign each new questionnaire a unique ID, from an AutoNumber field in a
table or another way
* capture the new questionnaire ID in a global variable, or pass it from
form to form, and use it to select the correct records

You might also look at reducing the number of forms; one per question seems
excessive. You can use page breaks on a single form.

Post your db structure and I might have some other ideas.

"Jason A. Thompson" <ja*@northwestern.edu> wrote in message
news:a9**************************@posting.google.c om...

Dear Access Gurus,

I have a database which I hoped to use to administer questionnaires,
or rather that someone who knows nothing about Access could use to
administer them. Each q'aire item is on a different form and I dropped
in command buttons on each to move forward and backward through the
"pages" of the q'aire. Problem is, the first record in the common
underlying table is overwritten each time we go through the q'aire.
(The code to open the next form is accompanied by code to close the
previous -- originally I thought the problem was that multiple forms
were attempting to write to the same record.) On the first form, which
launches automatically via an autoexex macro, I assign some variables
via VBA code in a new record and this works correctly each time.
However the controls on subsequent forms seem to point to the first
record only. It feels like a "gotcha" kind of problem that many others
have probably solved but I haven't been able to find a solution in the
FAQs. I figure it has something to do with record navigation that must
be done within each form as it is opened, but have not been able to
get recordset.MoveLast to work, for instance. Assume for the purposes
of this question that I am stuck having to fix this database
application and that other well-known solutions for questionnaire
administration are not available.

Many thanks for info/pointers.