If then Else

[jlg5454]

I need a field to say Bank 1 if opt 1 is selected or bank 2 if opt 2 is selected. I can not seem to get this to work.

Private Sub txtwho2_BeforeUpdate(Cancel As Integer)
If optwho = 1 Then
txtwho2 = "Bank 1"
Else: txtwho2 = "Cardella"
End If

End Sub

Thanks for any help

 

[PHV]

I don't think you may change the value of a control in its own BeforeUpdate event procedure ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jlg5454]

Sorry, I'm a novice. So your saying I should do this in perhaps the optwho control's after update.

 

[genomon]

Or its click event.

"Time flies like an arrow; fruit flies like a banana."