Calling query SQL from VBA - Error 3326, Not Updateable

[hcruz]

I am trying something new in my database in that I would like to call ALL or at least most of my queries from VBA.

I have managed to test that out with my first query successfully, however I get the error 3326 - this record is not updateable when I use the code. In the current state the user would need to End or Debug, which I would like to suppress if possible.

Is there a problem with calling SQL code from VBA that can't be updated? It seems to me just a normal result of some query strucutres.

Thank you to anyone who can offer advice or solutions.

Heather

[orange]

See if any of these apply
http://allenbrowne.com/ser-61.html

http://allenbrowne.com/subquery-02.html

[hcruz]

Thank you for the reply. I do understand why the query is not updateable, I am wondering why I get the error when I call the query SQL from VBA. I certainly do not get it when I run the query from the query design.

I looking for a way to suppress that error.

Thanks,
Heather

[orange]

I do not understand why a query would run from the query design interface, and the same query would not run from vba.
Can you please post the query and related vba etc.