>>>In my prg I have:
>>>[tmpfil='tmp'+sys(2)
>>>copy to &tmpfil
>>>use &tmpfil
>>>do form bgrid1]
>>>but I get "unknown member grid" error mess.
>>>
>>>>You should use
real grid name.
>>>
>>>Ok, errors are gone now. my code in a button on the form contains:
>>>thisform.grid1.RecordSource="&tmpfil"
>>>thisform.refresh
>>>HOWever I get a blank grid. tmpfil=tmpfil='tmp'+sys(2) and IS a real working dbf.
>>
>>Mr. Bowen, did I ever send this line "&tmpfil"? You must specify either literal alias or use macros without quotes.
>
>I tried the macro w/o quotes and I get error "variable TMP48456 is not found". Obviously I need to use macros as the dbf is quite dynamic.
Your dynamic table should be opened with some alias, and this alias is used as RecordSource.
Edward Pikman
Independent Consultant