Yes/No feature, Tabs depending on answer & Pop-up forms

[Lindros]

I am just beginning work on a new database. It has many yes/no questions. Sometimes when the answer is yes, it will lead to pop up forms to ask further questions, and then will come back into the database with a few other questions. However, when the answer is no, is there a way to make Access then skip through the next set of questions? This is a survey and it will not always be necessary for every question to be answered. I'd like to avoid having the person tab through all the other questions in those cases.

I have also never done pop up forms before. I've only had a subform included on a main form. I printed the information in Access about how to do the pop ups. Any quick tips/help you can give me there would be appreciated.

Keep in mind that I do not deal with code at all. I'm not good at reading it and certainly couldn't write it if I tried. I tend to build queries, create crazy formulas and use macros to manipulate data the way I want it. I've created some sweet databases, but my background is more with Excel. Formulas I understand, codes I do not.

Thanks for your help!

Michelle

 

[fneily]

If I understand you, for the NO answers, since you know how to create macros, create a macro with the OpenForm Action, fill in the appropriate arguments at the bottom. Then go to the AfterUpdate event of the NO option and place the macro name there. Doing this, you can then branch off to anywhere you want for all the NO's.
Coding is the way to go to make databases user friendly. A small amount of code can save you hours of time and alot of headaches in development. Just look at the code of others to learn it.