>Hi John, thanks for the reply.
>
>It's given me food for thought, although I think for a more generic solution the code could be in a grid method, then 'thisform' replaces 'oForm', and the WITH statement becomes 'WITH this'.
>
>Regards,
>Alan
Alan,
thanks for the reply. Yes, doing this as a grid method would work just as well. For changing between tables you could use a memvar for the table part of the column controlsource.
We still have this thing here about doing most things in PRGs. Mostly because you can have debug on and not have all your source code in the compiled EXE and because the VFP editor is so weak (unless you are addicted to IntelliSense).
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn