I don't know. I do it with the way I said if I need and works for me.
Cetin
>Cetin, I did waht you suggested , but with no luck.
>I then moved code to the Valid of MyStkGrp which DID work e.g.
> This.Parent.cboStock,Rowsource = 'Select * from.......'
>
>I dont understand why this is necessary. On the same form, I have another combo box which works perfectly without having to resort to this.
>
>My other combo that works: Select * from MyFile Where Myfield = 'XXX'
>
>The only differencr I can see from the two combos is :
>
>On the combo that did not work, the select field was depending on data entered on the form (i.e. MyStkGrp.Value)
>
>On the Combo that was ok, there was no dependance
>.i.e It was selecting based on a value ('XXX')
>
>I also set up another form from scratch just to test out and I was able to replicate the problem.
>
>Woild you have any idea why there is different behaviour for the two combos ?
>
>Regards,
>
>Gerard