Hello all;
I have a form with two combo boxes. Data sourse for the first combo box is set to a field in a parent table. What I'm trying to do is to set the data source of the second combo box to be a query result, based on the selection of the first combo box. So far I tried including a SELECT INTO ARRAY statement in the 1st combo box's VALID property, but for some reason the array size is not properly adjusted appropriatly (I thought this is suppose to happen automaticly).
I also tried setting the RowSourceType to SQL Statement, and can't get that to work either ....

Any ideas what I can try from here??


Thanx in advance

Kia