Message Box Yes Or No

[bradwould]

I have a Macro that I made to archive 4 different tables...using append queries and delete queries and attached the macro to a button on a form. I had to disable the warnings because there were just too many of them...i was wondering if there is a way to customize one warning (like: Are you sure you want to do this? YES NO) is there a way to do this and add it to my existing macro. I want to give the data enterer a chance to make sure they understand what is going on. I know i could create another form as a secondary confirmation screen and have done this for the time being but a pop up warning would look much more professional

thank you in advance

 

[FoFa]

You can create a function that asks, and returns true or false (boolean) and use that function call in the conditions section of the marco. When that macro line is hit, it will execute the function (which contains your msgbox) and then returns true or false to the condition and you can handle as required from there.