I am new to using Access, and hope that someone will be able to help with a
problem I'm having with my database:

I created a skills assessment test for my department at work. It has 124
separate forms, all linked to one table (one sign in form, and 123
questions). I have macros that close one form, and open the next one. It all
works just fine, EXCEPT that the responses to each question are not
populating in the same row of the table (the sign in information and
question 2 are populating the second row, and all other questions are
populating the first one). I've checked the properties of all of the
individual forms, and there doesn't appear to be anything different between
them. I'm stumped (but again, I'm far from an expert). Does anyone have any
ideas? I'm using Access 2000.

Thanks!

Joe:

My best guess is that you are not saving the record when you leave
form A for form B.
In that case all the forms would, in fact, populate the same record in
the table.
So, in the close event put in an explicit save:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70
This should be the first line in the on close code.
it must be before the form close and the new form open commands.
If this fails I would need to see the db.

Good luck
Ira Solomon




On Sun, 20 Feb 2005 07:07:24 -0500, "Joe Ahearn"
<jahearn67 (AT) comcast (DOT) net> wrote: