>>>>I have created a SQL view in code ( because there is a bug in the view designer that will not let it create a join from a parent to 2 child tables), but every time I run it I get the message that the view already exists and do I want to overwrite it. Doe anyone know how I can turn this message off?
>>>>Tks
>>>You can't do a REQUERY?
>>
>>I hadn't thought of that. I have been recreating the view every time the code ran. What I should do is run the code to create the view once, and then just requery it after that. There is an advantage to creating the view each time though. Depending on the users selection I can create a different view. As this view is in the data environment of the report, then I only need one copy of the report and it looks at the right view each time. In other words, it would still be nice to turn off the message.
>>Tks Mike
>
>Did you set the table in your data environment??

Yes. I put the view in the data environment.