1 Table 2 Forms - Records on top of each other (1 Viewer)

[Tezdread]

Hi, I have one table but two forms to enter info into this table, when I enter data on the first form this goes on line 1 (record1) and when I then go to the next form and enter data, this goes on the next record?? How can I ensure that all records are on the same line...
(I can't setup separate tables at this time)

 

[Pat Hartman]

The forms are not synchronized. Each form thinks that it is adding a new record. Assuming that the forms are always filled in in order, when the first form opens the second form, it can use the where argument to specify which record the second form should open to. Make sure you save the current record prior to opening the second form though.

DoCmd.RunComand acCmdSaveRecord
DoCmd.OpenForm ......