Problem with sequential DoCmd's
Posted on 2016-09-27
I'm running three DoCmd's, one after the other -- a delete query to clear the table, an append query to add new data, and finally an OpenTable command to view the new data. The delete query and OpenTable command both work, but the append query doesn't. When the table opens, all the records have been deleted, but if I close and reopen the table, the new data from the append query shows up.
Do I need to open and close the table between the delete and append queries?