Error Message

[Access Virgin]

I have put a piece of code on the after update event of a form to insert what unit has updated the record last.

Private Sub Form_AfterUpdate()
Me.ProjectWithUnit = Me.Unit
End Sub


The form is made of a tabbed form. I have code on the load event to fill out 3 fields, the username, user status and unit. When I make a change and close the form the unit is inserted into the field but then an error message appears, "You cant save this record at this time.. you may have encountered an error while trying to save a record."

I cant understand what ive done wrong

 

[Mile-O]

BeforeUpdate

 

[Access Virgin]

thanks, works a treat now!