To update a textbox based on list box

[johnpallian]

Dear Friends,

I have searched for this but I couldn't find , I'm sorry this was already discussed.

I Have created form , in which I want to update a textbox, based on the value of list box.

I have YES,NO as the rowsource for the list, and 3 textboxes, name totalloan,totalo_s,totalp_o
Now ,if user selects YES in the list box, totalp_o should be (totalloan-(totalo_s+1000))
if user selects NO in the list box totalp_o should be totalloan-totalo_s

Please help me out...
I tried this
'Private Sub fa_afterupdate()
'If fa = YES Then
'Me.totalp_o = me.totalloan - (me.totalo_s + 1000)
' ElseIf fa = NO Then
' Me.totalp_o = me.totalloan - me.totalo_s
' End If
'End Sub

 

[ajetrumpet]

check out this