Create A New Record From Same Data

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" wrote in message
nk.net
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

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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

"Cassandra" wrote in message
nk.net...
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


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.