bound textbox doesnt update

[Gazza2]

Hope someone can help with a strange problem.

I have a form setup as a continuous form with 2 combobox and 5 textboxes on it.The form is bound to a query.

The combobox is used to select the partno from TblProducts and one of the textboxes is bound to the description field of this table.

When i select the partno from the combobox and the focus moves to one of the other textboxes the description field doesnt update, it just stays blank.

Any help\ideas would be much appreciated

Thanks
Gareth

 

[vbaInet]

What is the Description field bound to? The textbox? If it's the textbox and the this control is in the Detail section of your form, then it won't work as expected in a Continuous form.

 

[Gazza2]

Thanks for the reply vbaInet

The decription textbox is a field in the products table that is one of the tables that is in the query that the continuous form is based on.

Basically when I select a product from the combobox the description should automatically fill in.

The continuous form is a sub form, I have a similar setup on the main form for selecting a customer from a combobox and it fills in all the other textboxes but i cant understand why this one doesnt work.

Hope that makes more sense

Thanks
Gareth

 

[vbaInet]

Where is the combo box placed? In the Detail section of your form?

Lets's see a screenshot of your form with the combo box and textbox labelled.

 

[Gazza2]

sorry for the late reply vbaInet.

The combo box is in the detail section of the form.

I have attached a screenshot of the form which i hope makes sense.

 

[boblarson]

How are you assigning the value of the description to the text box? It isn't going to do it automatically.