Retain Value of Previous Record

[Bart]

I have a form name "notepad", field name "topic" and "Add Record" command
button. I want the value of the field name "topic" to be retained everytime I
click the command button "Add Record" to avoid retyping of the values in the
field name. Any help?

Thanks!

 

[Jeanette Cunningham]

Hi Bart,
you could set the default value for that field/control in its after update
event.
When user opens the form it will be blank, after they enter a value it will
be entered for the next record.

Private Sub Topic_AfterUpdate()
Me.Topic.DefaultValue = """" & Me.Topic & """"
End Sub

Note: that is 4 double quotes either end of
& Me.Topic &


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Bart]

It works! Thanks Jeanette

Hi Bart,
you could set the default value for that field/control in its after update
event.
When user opens the form it will be blank, after they enter a value it will
be entered for the next record.

Private Sub Topic_AfterUpdate()
Me.Topic.DefaultValue = """" & Me.Topic & """"
End Sub

Note: that is 4 double quotes either end of
& Me.Topic &


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia