Tupacmoche
Registered User.
- Local time
- Today, 15:51
- Joined
- Apr 28, 2008
- Messages
- 291
I have put the following code into the After Update event of a text box on a form:
Private Sub PreDepositedCheck_AfterUpdate()
If Me.PreDepositedCheck.Value = 1 Then
Me.PreDepositSource.Value = "SDE" 'This value should be set
Me.PreDepositOrigBank.Value = "C0010" 'This value should be set
Else
End If
End Sub
The point is to make assignments to the columns PreDepositSource and PreDepositOrigBank as above. But nothing happens. I should mention that this text control along with several others are updated via a vba script. Is this the correct event to put this code into?
Private Sub PreDepositedCheck_AfterUpdate()
If Me.PreDepositedCheck.Value = 1 Then
Me.PreDepositSource.Value = "SDE" 'This value should be set
Me.PreDepositOrigBank.Value = "C0010" 'This value should be set
Else
End If
End Sub
The point is to make assignments to the columns PreDepositSource and PreDepositOrigBank as above. But nothing happens. I should mention that this text control along with several others are updated via a vba script. Is this the correct event to put this code into?