change textbox value after combo update

[arctushar@yahoo.com]

Hello
I have combo box. Its values are from a query. No I want that after updating value of combo the value of text box will change. For example

1. I have a table named table_bill containing Item & Description field
2. In a form name form_bill containing one combo box. Values of this combo box is items of table table_bill.


3. Now I want that when I change the value of combo box automatically value of text filed Description will change. And the value will be corresponding description of item from table_bill
Plz Help me

[RuralGuy]

Did you use the ComboBox wizard to help you create this cbo on the form? The wizard knows how to do what you want.

[arctushar@yahoo.com]

My combo box is working, but I need to put data in the text field from query based on combo box.

[RuralGuy]

I don't quite understand what you need. What is the query, and what info from it do you need?

[arctushar@yahoo.com]

I have a table

Item Description
2.A 10" Brick Work
2.B 6" brick work
3.A 10" RCC
3.B 5" RCC

In a form there is a combobox named item_combo whose values are 2.A,2.B,3.A,3.C
and a text field named description_text

Now If I select 3.A from item_combo. I want that description_text box value/text will be 10" RCC

Hope this will help u to understand

[RuralGuy]

Change the Bound field to 2 and see what happens. It is on the Data tab of the cbo property sheet.