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