HI, I have created a delete query that when run is working as intended :
DELETE tblEventElementIssue.ShowElementIssueID, tblEventElementIssue.EventID, tblElementIssue.ShowElementID, tblElementIssue.IssueID, tblEventElementIssue.* FROM tblElementIssue INNER JOIN tblEventElementIssue ON tblElementIssue.ShowElementIssueID = tblEventElementIssue.ShowElementIssueID WHERE (((tblEventElementIssue.EventID)=Forms!frmEventIssueLog!EventID) And ((tblElementIssue.ShowElementID)=Nz(DLookUp("ShowElementID","tblShowElements","ShowElement='COTG'"),"")) And ((tblElementIssue.IssueID)=Nz(DLookUp("IssueID","tblIssues","Issue='No New Issue'"),"")));
Using the SQL to VBA tool available here it translated to :
Just a thought but you may have extra spaces at the end looks like 2 spaces on some. I know when I do this I get error when I forget to double check on this as for the variables try it..... but 1st make a backup. also I do have problems with single quote and sometimes it works when I change it overt to double quotes. give it a shot and see what happends.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.