Record advances to new record between forms

K

kenthefisher

I'm fairly new at this so bear with me. I'm designeing a database with six
forms and 4 tables. I have a main form that contains 6 subforms. The subforms
are placed on the main form by means of six tabs. The datasources for the
subforms
are three tables, and one other table which is connected to the three tables
in a
one to many relationship. The problem that I am having is that when I switch
between the subforms to enter data the first form is updating and giving me a
new record. This causes the fields of data to be in a new record. How can I
fix
this problem? In other words the fields from the first form are in the
first record
and the fields of data from the the second record are on another record
(both forms
enter data in the same table).
How can I prevent this or work around it?
Thanks for any help!:). Ken Welling
 
Top