Copy and paste records on form.

[FL]

I have users to like to copy data in all fields of a form and paste to a new
blank record. The form has many fields and this method makes data entry
easier for them. However, I had a problem with the form that when users use
right arrow on record selector to advance to next record they would create
multiple blank records by mistake. This happens obviously and only when they
are at the end of all records. Most forms will not advance beyond one new
blank record. However, this form does. Not sure why. To solve this
problem I created a rule in the table design to force entry on one field.
But, users now say they can no longer do the copy and paste without first
making an entry in the field I created the rule for. How can I fix my form
to not advance automatically at end of records and not create multiple blank
records?

 

[Klatuu]

Why in the world would you want to create multiple identical records in the
same table? Either you do not have a relational database design or what you
really mean is copy some of the controls to use in the new record and fill in
the rest.

Can you provide some more detail on what you are trying to do.

 

[FL]

Klatuu, I did explain that users do this because it makes data entry easier
for them. Anyhow, copy some and fill the rest will do for this purpose. The
real problem is how can I prevent my form from advancing and creating
multiple blank records. Most forms will stop at the last record and open a
single blank record for next record entry. Mine form is sensitive to click
of the right arrow on record selector and will create many blank records as
long as the right arrow is mistakenly clicked too many times or held down.
This problem must be caused by some field calculation that happens every time
they enter a new blank record. Therefore, the database will immediately see
the blank record as a record with data and allow the creation of the next
immediate blank record and so on.