automaically close window

[foobar182]

Hi. I have a form the when a button is clicked in it, a table is created. Problem is, most of the time an old table of the same name is over written. So i get 3 boxes popping up asking if im sure i want to do this. I need to automate the process so that OK is automaticall selected for the user. Any ideas?

Thank you

 

[Carol]

Why inform the user at all that something in the background is going on to accomplish the task at hand. At the beginning of your code on the On Click of your command button, place the following:

DoCmd.SetWarnings False

Then at the end, set the following:

DoCmd.SetWarnings True

This will set all warnings off and then on again after it runs. But if you really want to advise the user that the data in the table is being rewritten, then you could do up a custom message box to relay this message with an OKAY button.