Use Plus key (+) to repeat info in new record

[Randy]

I need a way to use the + key to enter a new record and also repeat a few
fields from the previous record at the same time advancing the date by one
day. I am converting from a paradox database. This is how it was done in
paradox. I have been instructed to make the access db the same as the old
paradox. Less confusion...I hope someone has some ideas...Thanks..Randy

 

[Michel Walsh]

Hi,


You can carry over the last record value as "default values" for a new
record.

In the AfterUpdate event of the FORM, add line of code like:


Me.ControlName.DefaultValue = """" & Me.ControlName.Value & """"


for each control to carry over. When a new record is created, the "default
value" is proposed to the end user. That would occur, automatically, without
having to push any key, just have to create a new record.


Hoping it may help,
Vanderghast, Access MVP