Subforms: User data entry accidentally creates multiple records

[David Kistner]

We have a data entry form with several subforms. Often when a user
enters data the subform is accidentally advanced to a new record so part
of the data is entered in one record, and part in a second record. I've
disabled the record advance buttons on the form thinking this was the
cause but it still happens frequently. Frankly I'm not sure what they
are doing to cause this to happen (when I fill out a form it never does
this).

What else can I do to make it impossible for users to do this? Thank
you in advance for your help.

- David Kistner

 

[PC Datasheet]

David,

Open your subform in design view and go to properties - Other tab. Set the
cycle property to Current Record. It's probably ow set to All Records which
when you get to the last tab field on the form, a tab or enter will take you
to the next record.