textbox info based on cbo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top