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

  • Thread starter Thread starter Randy
  • Start date Start date
R

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
 
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
 
Back
Top