Multiple choices combo box

[ren1104]

I am working on creating a form where I have the main questions and sub answers, for example:
1. This is question number one
2. This is question number two
2a. Sub answer 1
2b Sub answer 2
3. This is question number three
3a. Sub answer 1
3b Sub answer 2
3c Sub answer 3
For the each of the main question (question #1,2 and 3), there will be a drop down menu with a choice of either 1 or 2 or 3 or 4 and each of the sub answers will have a drop down menu with a choice of either a Y or N

I can’t figure out on how to have a combo box where I can control it by the question number so it will show the correct choices.

Please help.
Thank you.

 

[dkinley]

What you are looking for are cascading combo boxes. These are a chain of combo boxes that are dependant upon another to determine what is displayed.

There is a demo on this thread ..
http://www.access-programmers.co.uk/forums/showthread.php?t=155389
that you can download to see how this is done.

Hope that helps.

-dK

 

[ren1104]

I looked at the cascading combo box but I don't think that's what I need. I am attaching the view of the form, where the drop down menu is either showing "1 or 2 or 3 for 4" or "y or n", it depends on the question number. I did find a way where it shows the choices according to the question number, but when I choose "1" on questions 2, all the combo box shows 2.

Thank you.

 

[dkinley]

Any way you could post the db?

-dK

 

[ren1104]

Attached is the database. There are 2 tables:
- Lookup contains the QNO and Answer
- tblQuestions contains the questions and QNO
I am using the QNO to determine which choices to go with which type of questions (main or sub)

The form is Form2.
Thank you so much for helping me.

 

[ren1104]

Dkinley,
I figured it out on how to link the combo box to a type of question but my next question is on how to add a memo box under each subanswer, example:
2. This is question number two
2a. Sub answer 1
2b Sub answer 2
2c This would be a memo box, where the user can manually type in.

I have no idea on how to make a combo box switch to a memo box when certain question is applied.

Thank you.

 

[dkinley]

Sorry Ren ... I couldn't respond sooner - something funny was up with my net.

After taking a look, you have some normalization issues but if your database is small and going to be a fire and forget sort of thing, it should not be an issue.

I attached what I did after you posted the dB, but it seems you already had it solved. I added a bit to make the write in appear, but the problem is you are using a continuous form - it works on current form view.

Well, it might not be a problem, but I have never and probably will never use continuous forms so my knowledge on those tricks and tips are about zero.

Perhaps someone who is better can assist?

-dK