"Cassandra" <cv********@bellsouth.net> wrote in message
news:xT****************@newsread3.news.atl.earthli 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)