>Hi,
>My program has two combo boxes. The value selected in combobox A determines the rowsource for combobox B.
>
>I tried to do it this way:
>
>ComboBox A - Interactive Change
>
>do case
>case this.text = "A"
> thisform.ComboBoxB.rowsource = TableAlias.Field1
>case this.text = "B"
> thisform.ComboBoxB.rowsource = TableAlias.Field2
>endcase
>
>thisform.ComboBoxB.refresh()
>
>But ComboBox B is not showing the right values. Do I need to define any property other than the rowsource?
>
>Thank you.
>
>Ria
Ria,
I think you have to set (once)
thisform.ComboBoxB.rowsourceType = 6
You may also have to set thisform.ComboBoxB.ColumnCount and thisform.ComboBoxB.ColumnWidths
also check that the rowsource is between quotes
thisform.ComboBoxB.rowsource = 'TableAlias.Field1'
that's all I can think of
Gregory