After Update Code

[Bob Vance]

I have a combo box [cbStatus] which has a row source Yes;No
and a text box [tbInvocing] if [cbStatus] is "No" can [tbInvocing] show "No"

 

[George]

Dear Bob, use the following code on the After Update event (I tried it in
Office2003:

If Me.cbStatus.Value = "No" Then
Me.tbInvocing= "No"
Else
Me.tbInvocing= ""
End If

Hope this helps,

GeorgeCY

Ο χÏήστης "Bob Vance" έγγÏαψε: