Hi
I have a command button on a worksheet that opens and allows additions to a linked MS Access DB. In the macro after the line to open that DB I have placed a command to refresh the data. I am pretty sure this is happening before the edits in the DB have taken (and the focus has come back to Excel from Access) Is there a way to ensure the refresh does not take place until after I have closed the DB and returned to Excel. In Access I would simply use acDialog.

TIA
Andrew