Populating field with value in previous record

[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.

 

[Denise]

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.

 

[Yair Sageev]

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.

 

[Denise]

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.

 

[Yair Sageev]

Thanks Denise, I will try your technique.

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.