Populating field with value in previous record

  • Thread starter Thread starter Yair Sageev
  • Start date Start date
Y

Yair Sageev

I have continuous subform. I would like to populate a field of each new
record with the respective value in the previous record. Is there any way
to do this?

Thanks.
 
That's an easy one. Hit Ctl + ' (apostrophe). Access has
a list of shortcut keys that perform a variety of common
tasks. Look up shortcut keys on the help menu for the list.
 
Thanks! I sometimes get the error that LinkMasterFields is annoyed by this
action, but most of the time that works.

Also, I would prefer if it just automatically did this. When a new record
field pops up that control is already populated.
 
I have a form that does automatically populate a textbox as
you describe. What it does is save the value in a global
variable and then when the user moves to a new record
(using the BeforeInsert event of the form) the value of the
variable is automatically assigned to the textbox using a
Me.tbxName = globalvarName.
 
Thanks Denise, I will try your technique.


Denise said:
I have a form that does automatically populate a textbox as
you describe. What it does is save the value in a global
variable and then when the user moves to a new record
(using the BeforeInsert event of the form) the value of the
variable is automatically assigned to the textbox using a
Me.tbxName = globalvarName.
Click to expand...
 
Back
Top