I prefer to use the On Enter event.
I would use code like this:
Code:
Private Sub VehicleOwnerLastName_Enter()
If IsNull(Me.VehicleOwnerLastName) then
Me.VehicleOwnerLastName = Me.StaffLastName
End If
End Sub
IMHO, you are not following the rules of data normalization. ou are creating repeating data.
I woudl recoment eat you has a people table. You wil look up the Primaryu key form the people table for the the Staff and the Vehicle.
I would have:
Code:
Private Sub VehicleOwnerID_Enter()
If IsNull(Me.VehicleOwnerID) then
Me.VehicleOwnerID = Me.StaffID
End If
End Sub
AN even better design would use a child tbale with one record per person with a field for the type (staff, owner) and People ID.