Nested combo box is not working

[frantik]

Hi I have a form that contains two combo boxes:

Cb_Category
CB_Subcategory

The contects of Cb_subcateogry are dependant on the value selected in Cb_Category. Or rather it should be! It is not working.

I have placed the following in the critera for row source of Cb_subcategory:
=[Forms]![Fm_assessment]![cb_category]

I have tried the following lines everywhere - well On After update for Cb_Category and On From current.

forms![assessment].cb_category.refresh
forms![assessment].cb_category.requery
Me!cb_category.requery

Can Anyone offer any advice please?

Thank you

 

[frantik]

I should also add - that the row source is a table consisting of colums: Category and subcategory and relevant records are present

 

[dRahme]

Hello, if cboCategory has more than one column, then you might need to refer to a specific column

=cboCategory.column(0) - 0 being column 1

If it is an updating problem you can place in cboCategory's after update event

me.cboSubCategory.setFocus

and then on CboSubCategory - onEnter event requery the combo box.

Hope that helps.

 

[frantik]

Thank you DRahme

Unfortunately still no joy. What is strange is that if I substitute a text box for the first combo box and typein the category it works.

Is there something special I need to do with the combo box?

 

[PHV]

I believe you requery cb_category instead of CB_Subcategory

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[frantik]

Thank you very much for your help guys

the problem was the bound field from the Cb_category box

Much appreciated