Update Query Error "Report"

[tomc]

I have a master table of folders, tblFolders. Then I have an input table where users enter new location info when folders move. It isn't practical to call up individual folders and then change 4 fields, so they input to the move table. I then update the master table from the move table based on a folder existing in tblFolder and on that record having a null value in the destroyed field.

There are occasionally data entry errors or a folder is added to the move table that should have been destroyed. What I want to do is to update tblFolder and then delete the records from the move table that matched the update criteria, leaving only the errors in the move table. Users can then correct the errors and run the update query again and again until there are no errors.

Using standard query design I can update tblFolder alright, but I am having a hard time then deleting the source records from the move table. I've done everything so far using query design, not code, but if code is the way to go so be it.

Any help with this will be greatly appreciated.

Tom

 

[tomc]

Oh, Yeah, When I have tried to make a table of the updates tblUpdates and then to delete that table for the move table I get the message "Cannot delete from specified tables". The move table is just a straight data entry table, nothing fancy.

tom