Create A New Record From Same Data

  • Thread starter Thread starter Cassandra
  • Start date Start date
C

Cassandra

My data entry form has thirty one fields. After I go to a new record and enter
all the fields, how can I create another new record out of the same data?
Sometimes when I am entering new records, only two or three fields change from
one new record to another. If I could create a new record out of the same data
and then edit the two or three fields, it would save a lot of data entry time.

Thanks!

Cassandra
 
Cassandra said:
My data entry form has thirty one fields. After I go to a new record
and enter all the fields, how can I create another new record out of
the same data? Sometimes when I am entering new records, only two or
three fields change from one new record to another. If I could create
a new record out of the same data and then edit the two or three
fields, it would save a lot of data entry time.

Thanks!

Cassandra
Click to expand...

If you want this to happen automatically, you can use the form's
AfterUpdate or AfterInsert event to set the Default Value property of
each bound control to the value it has for the record that was just
saved. For example:

Private Sub Form_AfterInsert()

With Me!Control1
.DefaultValue = Chr(34) & .Value & Chr(34)
End With

With Me!Control2
.DefaultValue = Chr(34) & .Value & Chr(34)
End With

With Me!Control3
.DefaultValue = Chr(34) & .Value & Chr(34)
End With

' and so on ...

End Sub

There are ways to condense this code so as not to have to name each
control individually, but this is the basic idea.
 
Cassandra said:
My data entry form has thirty one fields. After I go to a new record and enter
all the fields, how can I create another new record out of the same data?
Sometimes when I am entering new records, only two or three fields change from
one new record to another. If I could create a new record out of the same data
and then edit the two or three fields, it would save a lot of data entry time.

Thanks!

Cassandra
Click to expand...
You could choose to show "Record Selectors" in the form (a narrow column to
the left of the form with a right pointing arrow at the top), right click
this column, choose copy, go to a new blank entry, right click the same
column and choose paste.
 
Back
Top