Combo Box Problems

[brentos2004]

Hi Im new to the forum and new to the world of using VB in Access so any help with this would be appreciated.

Ive created a database that Is going to create data sheets. I have two main tables ; Major_Cat and Sub_Cat that are linked in a one to many relationship.

Ive created a form that has lots of combo boxes when im using queries to populate the combo boxes. I have it set up so when an option is selected from a combo box the text relative to it comes up in a text box at the side of it. Ive done this by adding this code in the after update event.

"Private Sub Precautions_AfterUpdate()
Me.[description] = Me.[Precautions].Column(1)"

What I want is to be able to get it so when the user has selected one option it opens another combo box with the same options so when they select the next option it populates the same text box as before with another description.
I want this to happen until the user moves on to the next section and so on.

I know this is probably not explained as well as it could be.

If this cant be done another option would be to use a list box so the user can select as many options from the box and the relative text will be populated for all of the items selected in another list box at the side of it.

I have tried doing this but I can only get it to populate the box at the side with one of the relative peices of text rather than the text for all options selected.

I know this is long winded I just wanted to try and give as much info as possible. if any one knows what im going on about please reply

Thanks
Brent

 

[supercharge]

Rephrase:

Let's say one combo box has a list of A,B,C,D. User selects A, A shows up in the text box and also show another combo box with the same list of A,B,C,D. Then user selects B in the second combo box, B shows up in the textbox replacing A.

Is that what you want to do?

 

[brentos2004]

sort of but says theres a combo box with a b c d in and theres text associated with it so in the table ive got a field called heading and field called sub_text so each heading has subtext that relates to it.

so when a user selects a from the combo the associated text pops up in a text box next to the combo. then I want it to show the combo box again with the same fields and they choose one then the text associated with that goes into the text box as well but keeps the first one in there as well.

Basically what im doin is a form where there can be 3 or 4 options for one main heading so for example the subheading could be precautions and for that heading there is a combo box with head , hands , ventilation etc and when the user selects one the text appears in the box next to but there is more than one thing that needs to be included

Hope this helps

 

[brentos2004]

Has anyone got any ideas on this ? I really need help to get this sorted