By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,034 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Create A New Record From Same Data

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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)
Nov 12 '05 #2

P: n/a
Jen
"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

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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.