Last record, new record, coding

G

Guest

How would I code the following logic, to be put in a field's on_enter event?
The field is in a subform, in datasheet view.

If I'm in a new record
and it's not the only record
and the first field in this record is not null
then
this field I just entered now equals the value I entered for it in the
previous record.

Basically I just want to automate the Ctrl + ' function.
I do not want to do this using the .defaultvalue attribute.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat fields from last record 4
Automatic deletion of subform's record 12
get last record 1
Access Automatically Send a notification email once a record is added 0
What strategy to add a new record on subform? 2
Save New Record from Form 2
New Record Question 9
Access 2007 Previous Record 8

Top