<snip>
>When using macro expansion with an object property you use two dots - one is the usual dot and the other denotes that the macro expansion ends "here." The expression would look like:

SCATTER NAME THISFORM.MyProperty
>lcProperty = "MyProperty"
>? THISFORM.&lcProperty..Field1

>I tried every combination of your ThisForm.FileName property and "&" and extra dots and always got an error of some sort, but I can't say exactly why it doesn't work.

Cindy,

It doesn't work because Sql Select expects table/cursor name or alias but macro substitution either breakes on the dot in ThisForm.FileName or result of nacro substitution isn't a name. You would have the same problem with your object example if instead of lcProperty variable you use Thisform.cProperty.