9 linked forms - one table - many problems!

[JPP21]

I'm using the old Access 2 and if my work had Access 97 or better I could use Form tabs to solve this problem.
My problem is this -
I have muliple forms linked by command buttons with open form macros for each button. The forms are for data inputting response to a survey. The database is currently empty with 115 fields.
Every time I click through to the next form and input data, it adds the new data as a whole new record. I want to click through to the next form and input data to the same record as I had in the previous form.I've tried and failed many times but cannot figure out how to do this.
Any help with this would be greatly appreciated.
Thanks

 

[rbowes]

Have you tried opening all of the necessary forms at the same time, letting only one form appear at any one time? Each Exit button only closes the active form and makes the next in line appear. The exit button on the last form would be have a Save function.

How about making the ID for each respondant to the survey be the Primary Key for the table? In this last case, there cannot be more than one record per respondant.

The only other thing I can suggest would be to use VBA to handle the saving of the information.

Hope one of those ideas helps

BB

 

[Aivars]

Split your huge table to several smaller tables and create relationships between them.

Aivars

 

[EPT]

I agree with Aivers. Split you table into 9 tables that correspond to your forms and link 8 of the tables to a main table in a one-to-one relationship. Have the main table contain your RecordID and include this field on the other tables. Add control buttons to the main table to link to your other forms. On your button controls use DoCmd.RunCommand acCmdSaveRecord 'to first save the record then
DoCmd.OpenForm "OtherForms",,,"RecordID = " & Me!RecordID
to open the forms.
On the other forms, the default value for RecordID should be
Forms![MainForm]![RecordID]

HTH
Ed