Hi,
May I make one suggestion. Using an alias is a great idea. But the root of the problem may not have been touched. It may not be this, but there is something that I've noticed that is a bit strange. If you have a table that has a dash in the name, ic. Table-Name.dbf, you can USE it with that name, but if you try to SELECT it, you will get an error. To SELECT it, you would need to change the dash to an underscore, ic. SELECT Table_Name. As I said, I find this strange, but it's not the first strange thing I've dealt with.
Dana
>Hi Nadya,
>
>Thanks. My error went away. I tried using an ALIAS before asking for help, but I must have done something wrong because I got an error.
>
>I am not sure what you meant by the form name does not have to be intuitive? I have a table full of form names and I flip through the table until I get to the form I want to work with, then I press a command button to run this little routine. What did you mean? I don't understand.
>
>Thanks for helping me out of the mud.
Where's the damned Any Key?...too late