textbox info based on cbo

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a main form that has a continuous subform on it. In the subform there
are many fields but interest is two of them. There is a cbo with a textbox
next to it. When the cbo changes, the textbox changes accordingly. The cbo
is a bound field and the textbox is not. I have the following in the default
value property of the textbox; =[ChargeAccountID].[Column](2) and in the
click event of the cbo there is; Me.POChargeAccountType =
ChargeAccountID.column(2). The user may or may not select or change the
default value in the cbo. So, if the cbo shows 'zippy' as a charge acct, the
textbox would show 'product'. Next record in cbo show 'howdy doody' as the
charge acct, the textbox would say project. But what is happening is all the
textboxes change to project. Can't have that.

My concern is how can I have the textbox show only what the corresponding
cbo is about without changing the other textboxes in the other rows?

Thanks.
..... John
 
Back
Top