Populating control with previous data

[Coady.Barrie]

I have added the following code to my database Private Sub Upper_Work_Roll_Serial__AfterUpdate()
Me.Upper_Work_Roll_Serial_.DefaultValue = """" & Me.Upper_Work_Roll_Serial_.Value & """"
End Sub

to allow for the carrying over of data from a previous record to the new record, however the data does not carry over.
Any help is appreciated.

Thanks

 

[RuralGuy]

Have you tried displaying the .DefaultValue with either a Debug.Print or a msgbox?

 

[Coady.Barrie]

No I have not.
What would that tell me and how would I do that

 

[Coady.Barrie]

I found the solution to the problem.
I had a beforeupdate code that was preventing the afterupdate to work

 

[RuralGuy]

That's great! Thanks for posting back with your success and solution.