Hi Gelnn

I make a point of always including the . when I do &, just like I we have to put a ) after a (. That way, memory never fails me ;) and things like thisform.&lcmacro.. doesn't seem strange.

>If memory serves me the "." causes the macro to cease exapnding, you could do several things to get around this issue but I would recommend:
>

>Select * from (thisform.filename) ...
>

>Just use substitution as above and it works just fine.
>
>Glenn
>
>>I have a form property called thisform.filename initialized to "c:\test\test.dbf"
>>When I run a query using "Select * From &thisform.filename" it errors saying the table is not found.
>>
>>If I set the form property to a variable as follows:
>>lcfilename = thisform.filename
>>Select * from &lcfilename - the query works.
>>
>>Is it that a form property is not really a variable as far as macro substition is concerned.
>>
>>Gaylen