Well, Lius, it seems unlikely that this would work in either form... are you sure that the first form doesn't, sometime before the first use of the combo, replace the RowSource with a VARIABLE set from the property?

The "excuse" for this behaviour is that in THIS case the actual SQL is executed 'outside' of the environment (of the form OOP) and so cannot interpret THIS.... Personally, while I understand the nature of the problem, I think this STINKS. To me it represents a design flaw that should have been fixed by now.

good luck


>Hi, i just can't think why this is causing me problems, i will explain:
>
>I have a form, in this form I have 2 combos, each one of them are RowSourceType=3, and Row Source goes like this:
>
>

>Combo1= Select nombre_cad,codigo_Cad FROM cadenas INTO CURSOR sys(2015)
>
>Combo2= Select nombre_tie,codigo_tien FROM tiendas WHERE codigo_Cad=THISFORM.Combo1.Value) INTO CURSOR sys(2015)
>
>

>In the Interactive Change of the first combo, I make a Requery to second one.
>Both combos, are boundto=.T., and boundcolumn=2, and in this form they work great, but in a new form that I'm using, I'm getting this error:
>
>THISFORM can only be used within a method, and the help file says this:
>
>One of the following commands was used outside of a method: THIS, THISFORM, or THISFORMSET.
>
>You used the statement in a procedure, but it can only be used within a method.
>Move the THIS, THISFORM, or THISFORMSET command into the appropriate method.
>
>
>Ok why this works in the first form, and it doesn't works in the second one?.
>Thanks for your time.
>Luis