Replace a null field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello All
Thanking you in advance. I have a form with a field SoldBy which is usually
left empty (as it would often but not always be duplicate data to the
SalesManager filed). On close if the field is empty I would like it to be
replaced with the SalesManager field. Can anyone please help me with my
dilema. Many Many Thanks
 
You could do this in the form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Len(Me.SoldBy.Value & "") = 0 Then Me.SoldBy.Value = _
Me.SalesManager.Value
End If
 
Back
Top