Conditional Survery Questions

[Capo]

Hello Everyone,

Please let me say in advance that compared to many of you, I am an Access newbie, so pardon me if I miss some of what you're trying to say.

Here is my situation: I have been tasked with creating a survey. However, many of the questions are if/then. Here is an example:

"Do you like cheese?" If yes, procede to question 2, if no, procede to question 3.

Can I accomplish this within the functionality of Access or must I do it in VBA?

Any help would be appreciated!

 

[Dennisk]

Yes it can be done, I did something similar about 3-4 years ago.
Use a combobox with a yes and no value and in the after update event of each combo box enable/disable the approriate other combo boxes, then set the focus of the next question. However it does take a fair amount of code which needs to incorporated into the forms on current event.

 

[Capo]

Do you have an example I could look at of the type of code I would need to use?

 

[Dennisk]

See The Db attatched. The Patient Form contains a dental triage form that contains the sort of code you need and the Triage table is the structure.