Hello I have a form where there

[BT24]

Hello

I have a form where there is a List box then a combo box what i would like is for the the combo box to be updated when a entry in the list box has been selected. A problem that i have had is that the list box's rowsource is an Area and there are only 3 areas but the box is showing each area for each description so instead of having 3 there are 64. And it will not update the combo box. the field is coming from the same table for both the list and combo box
thanks for the help

BT24

 

[neillovell]

You may wish to rewrite that a little...

 

[BT24]

Sorry, i rewrote it, its thread181-362291. thanks for the help.