Retain Field Value

  • Thread starter Thread starter Lloyd
  • Start date Start date
L

Lloyd

I am a newcomer to Access and have a question. I would
like a newly created record to retain the value from a
field in the last record - that value could then be
changed as appropriate.

Is there a simple (or not so simple) way to do this?

Thanks

Lloyd
 
Put the following code in the AfterUpdate event of the field you want to repeat:

Me!MyTextBoxName.Default = Me!MyTextBoxName
 
I am a newcomer to Access and have a question. I would
like a newly created record to retain the value from a
field in the last record - that value could then be
changed as appropriate.

Is there a simple (or not so simple) way to do this?
Click to expand...

In the control's "AfterUpdate" event procedure, try inserting code similar to
the
following:

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

Replace "ControlName" with the name of the control in question.
 
Back
Top