Re: Open Query works under command button but not After Update event?
Actually, I don't think the quote marks are required because this is the sql of a saved query.
Have you actually looked at the table and checked that the update has failed. Until you posted the sql I had assumed that it was a SELECT query that would be displayed. An UPDATE query of course displays nothing.
Microsoft Community Contributor Award (2011)
If this helped, please click the scales at the bottom left of this posting.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
I have never failed. I have found a thousand ways that do not work!