>I know this is a bit symplistic but have you tried putting your SQL in the Valid clause of the first combo or in the gotfocus of the second?

Terry
Thankyou for your reply. I resolved the issue by trying "one" more thing!!!!
I defined the array as Public in the form's init, which works fine. But I found out that if the array size changes programitcally, the Combo Box 'NumberOfElement' doesn't update, and I must issue a ThisForm.cboMyCombo.NumberOfElemets = ALEN(aMyArray)

Regards

Kia