Copying from previous record entry

[Stiruchi]

When creating a new record, I want a couple of my fields to update
from the previous record depending on the name selected in staff name
field. This is not exactly copying from the last record in the
database, but the last record of the relevant staff name selected in
the first field in the form.

Thanks in advance for any help.

ST

 

[Stiruchi]

On Sep 21, 1:30 am, "Linq Adams via AccessMonster.com" <u28780@uwe>
wrote:

Yes, there is a date field.
Staff enter project related activity notes routinely. While the notes
will be different each time, the project details are likely to be
similar. So basically I want a couple of fields to copy from previous
entry to that staff. Saves having to select project name from a drop
down list each time.

Thanks again for any advice.
ST

 

[Allen Browne]

When creating a new record, I want a couple of my fields to update
from the previous record depending on the name selected in staff
name field. This is not exactly copying from the last record in the
database, but the last record of the relevant staff name selected in
the first field in the form.

There's a couple of ways to approach this.

If you want to copy most of the fields, use this approach:
Assign default values from the last record - Carry data over
at:
http://allenbrowne.com/ser-24.html

If you just want to set the default value for one or two fields, use this
one:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

 

[Mike Painter]

There's a couple of ways to approach this.

If you want to copy most of the fields, use this approach:
Assign default values from the last record - Carry data over
at:
http://allenbrowne.com/ser-24.html

If you just want to set the default value for one or two fields, use
this one:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

It's sad that this is needed. I came from a Pick background where the
contents of the last record was always available.
Since a Ctrl-" will fill the previous value into a field I suspect that it
exists in Access and could be exposed.
Them ThisField.LastValue is all that would be needed.