How do I control a text box via another combo box

[Gandor]

I have read through dsome o the other answers and I just can't seem to get it.

I have a table called employee information.

Within that table are two fields. Retail Title and Retail Incentive.

I have a form with a combo box for the the Retail Title.

This field looks to a table called Retial titles which is two fields...Title
and Incentive

What I want to do is have it so when I choose a title in the form it
populates the incentive in another text box.

The combo box column count = 2

What should by settings be for my text box?(That of course if I should be
using a text box and not something else)

 

[M Skabialka]

Assuming that ComboRetailTitle is your combo and has two columns;
ComboRetailTitle.Column(0) being the Title and .Column(1) the Incentive

In the AfterUpdate event of the combo box:

Forms!myForm!Incentive = ComboRetailTitle.Column(1)

Incentive should be the correct format for the info, e.g. currency, text,
etc.

HTH, Mich

I have read through dsome o the other answers and I just can't seem to get
it.

I have a table called employee information.

Within that table are two fields. Retail Title and Retail Incentive.

I have a form with a combo box for the the Retail Title.

This field looks to a table called Retial titles which is two
fields...Title
and Incentive

What I want to do is have it so when I choose a title in the form it
populates the incentive in another text box.

The combo box column count = 2

What should by settings be for my text box?(That of course if I should be
using a text box and not something else)

--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[Jon Lewis]

or just have =[ComboRetailTitle].[Column](1) as the Control Source of the
text box.

Jon