Subform PROBLEMS (multiple entries into table)

J

Julie966

I am hoping that someone can come to my rescue. I have a main form and 5
subforms. The data entry box is set to no. The table that drives the
subforms is linked to the main form with a one to many relationship.
Everything was running smoothly until yesterday.

When the user is entering the data in the subform (mostly checkboxes with a
few memo fields), the data is all there, but when he moves to the next record
the data is no longer disaplayed on the subform. However, the data is in the
table, but it is in the table 6 times, but not duplicates of each other.

What is causing this - I am thinking that the user is entering stuff by
jumping around and each time he tabs to a new page a separate record is
created.

I am soooooo frsutrated - any help would be greatly appreciated.
 
Top