Dialog box at start of macro with a YES/NO response

[vad60]

What I like to know is how to get a dialog box at the start of a macro to remind me to set a primary key on a table before the rest of the macro continues. The macro that I run is made up of many other macro's but if I forget to set the primary key on my main table (as I did yesterday) I then have a long manual process to correct my data. The reason I don't have the primary key set is that my raw data contains duplicates which I need to correct before I generate my end result. Once the duplicates area taken care of I then run this large macro to generate commands files to enter into my pbx. What I would like is to have a dialog box pop up asking me "Did you set the primary key in the Workbook table??" Then in this dialog box have a YES and NO button. If I select YES then it continues, if I select NO I would like it to open my Workbook table in edit mode so I can set the primary key, save the table and have the macro continue after I close the table. I need this because I have many distractions while working and I sometimes forget.
As always thanks in advance for your repsonse. This is the only place I come to for my Access help and always get helpful repsonses.

I am using Access2003

VAD

 

[highbulp]

Might it be easier to always run this process from a Form? Then you can have a form with the question, and you can have each button do whatever you want.


//Newbie answering a question

 

[vad60]

That was/is my plan but haven't had the time to create a form with the tight cut schedule we are on. I need this as a reminder only since I forget this step sometimes. This database is a tool I use and no one else.
I would really like to learn VBA since it seems that it is the better way to go.
Thanks for the reply.