>>>I have noticed that when I open a table with the code below, it get's reported as not open when I try to access it from a form. Why?
>>>
>>>
>>>Close Tables All
>>>FileName = Getfile("dbf","Select file number","Load")
>>>Use &FileName
>>>
>>
>>Just a sidenote. Always use name expressions whenever possible, they are faster and safer. In your case, if FileName contains spaces, your code won't work at all!
>>
Use (FileName)
>
>Tore,
>I support your advice in this case. But the 'faster' argument won't be a real argument here. Let this not be the start of a new debate. We've had those debates several times. But I wanted to react in order to let Grady McCue know about it.
I agree that in this case the word faster is irrelevant, but in many cases where you can choose between the & macro and a name expression, a name expression is much faster. That's why I wrote "Always use name expressions whenever possible".
And by the way, I agree that we don't need a new debate about this. :-)