textbox info based on cbo

[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

 

[Marshall Barton]

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?

You can not use code to set the value of an unbound control
on a continuous form without seeing the same value in every
row. That's bcause there is only one text box with one set
of properties.

Instead you either have to use an expression like
=combobox.Colummn(N)
or, the text box must be bound.

 

[JohnE]

I figured it out. Thanks for reading this.
.... John