Table structure and data display on form

[Dk11]

Thanks in advance to those that respond to my newbie questions
I need to design a form that works as such:

list box category 1
question a
question b
question c

list box category 2
question a
question b
question c

I then need to display a block of text (answer to the question) on the form based on the selection chosen, as well as saving the selection in a field for the current record. The text needs to always occupy the same space on the form. It seems there should be a simple solution.
Thanx!

 

[Dk11]

fixed

I used a hidden column in the combobox and
Me!OtherControl= Me!ComboBox.Column( index ) in the after update event. Seems to work
Thanx anyways

 

[Dk11]

OOPS - Actually...

It works great except that if I select, for example, question 'b' from category 1, then category 2 changes to question 'b' as well. The only connection I can see between them is that they are both connected to the same textbox in the afterupdate event.
How can I prevent the other categories from changing as?
THANX

 

[directormac]

I'm a bit sketchy on the relationship that these controls have to one another. As I understand it, you have three controls:

lstQuestion1
lstQuestion2
mmoAnswer

Yes? Now, you say that the mmoAnswer control should display text "based on the selection chosen". Based on WHICH selection chosen? If lstQuestion1 and lstQuestion2 each have a list of questions in them, which one is mmoAnswer displaying the answer for? Give us a little more detail on what you want to happen...

--Quizical Mac

 

[Dk11]

Fixed

Thanks for offering to help, I got it fixed though. Now off to learn about charts