Subforms: User data entry accidentally creates multiple records

  • Thread starter Thread starter David Kistner
  • Start date Start date
D

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
 
David said:
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
Click to expand...


Hi,
This helped...it's from another NG, but thought it might be good to post
it here in case someone else ever had the problem and is searching the
Internet for help:

"Open your subform in design view and go to properties - Other tab. Set
the cycle property to Current Record. It's probably now 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."

Thanks,
- David Kistner
 
They could be pressing Page Down on their keyboard, which will advance to
the next record.
 
Back
Top