Decision Tree

[RycherX]

Is it possible to design this in Access.

I envision a user to open a form that will ask a Y/N question. If user selects"Y" and clicks "next", a different question is asked on the next form. If a user selects "N", user gets routed to a different question.



So the idea is to have a user answer a series of questions driven by a behind the scenes decision rule.

If I store these decision rules in a table, can these rules drive the specific questions?

Moreover, after answering 15 questions, can I store the results of these questions for reporting purposes?

[MAF4Fam6]

I know of one way this can be accomplished: by using a Conditional Macro.
However, all decision rules would be stored in the Conditional Macro versus a Table. Your Conditional Macro can also update your results to a Table by using Update Queries which can then be used for reporting purposes onto a Report. Even better...you may even be able to use a Yes/No pop up window instead of a form when selecting your answer.
Hope this helps.

RC
Fruit Heights, Utah