E
efua20
I have a frame (fraTransaction) with 8 option buttons on a data entry from
(frmLNEX) that is linked to a table. How do i get the option buttons to
actually show text information in the table when the user clicks any one of
them. I unbound the frame and added a textbox (txtTransaction) that is bound
to my table but I keep getting an error "the value you entered isn't valid
for this field". Part of the code i tried is
Private Sub fraTransaction_AfterUpdate()
Select Case Me.fraTransaction
Case 1
Me.txtTransaction = "Appropriately Direct Caller"
Me.txtTransaction.Locked = True
Case 2
Me.txtTransaction = "Line of Business"
Me.txtTransaction.Locked = True
End Select
End Sub
Please let me know what i'm doing wrong. Any help would be very much
appreciated. Thanks.
(frmLNEX) that is linked to a table. How do i get the option buttons to
actually show text information in the table when the user clicks any one of
them. I unbound the frame and added a textbox (txtTransaction) that is bound
to my table but I keep getting an error "the value you entered isn't valid
for this field". Part of the code i tried is
Private Sub fraTransaction_AfterUpdate()
Select Case Me.fraTransaction
Case 1
Me.txtTransaction = "Appropriately Direct Caller"
Me.txtTransaction.Locked = True
Case 2
Me.txtTransaction = "Line of Business"
Me.txtTransaction.Locked = True
End Select
End Sub
Please let me know what i'm doing wrong. Any help would be very much
appreciated. Thanks.