Did you try Fred Taylor's suggestion of SET TALK WINDOW? That should at least take the message from your form and put it into a wait window. Then you can WAIT CLEAR just after the SQL SELECT.
Cheers,
Rich.
>Actually, I have status turned off. This message is appearing right on top of the active form and it's very distracting... plus, once it's there, it does not go away.
>
>Thanks
>
>>If it's appearing in your status bar use SET MESSAGE TO '' right after the SELECT. That will erase it so fast you probably won't even notice it.
>>
>>>tried that... still get the message
>>>
>>>Thanks
>>>
>>>>Try changing the SET NOTIFY to OFF
>>>>
>>>>>
>>>>>I set talk on so I can see a SQL statement's progress, but I don't want the message showing how many records were selected.
>>>>>
>>>>>I immediately set talk off after the SQL statement, but still get the message. This didn't used to happen, but I'm not sure what's changed...
>>>>>
>>>>>TIA
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing