>Hi all,
>
>I have a view with this code,
>
>SELECT DISTINCT *;
>FROM jbfic!familias LEFT OUTER JOIN jbfic!familiascli ;
>ON Familias.c_codigo = Familiascli.c_codigo;
>AND Familiascli.c_codcli = ?codcli;
>ORDER BY Familias.c_codigo
>
>In form DE i have noDataOnLoad=.t. but when i run the form it ask me to enter the value for codcli.
>
>I set this value for ex. in BeforeOpenTables and it ask again, and the same if i do it in the form load event.
>
>Any ideas,
>
>Thank's in advance,
>
>João Batista

It sounds like there is a Requery() somewhere in your code that is run as the form instantiates. Check the form and everything in the class hierarchy.

The reason setting a variable in those two methods doesn't work is because of scope. You would have to make the variable public. A private variable won't work because OpenTables is not called from the Load or BeforeOpenTables events. They execute in a pre-defined sequence determined by the Dev Team at MS.