Combo box eliminating already chosen data in previous combo box

[qabaselayan]

Hello everyone,
I'm currently working on a form that takes data from the user about a lesson plan.
The data is:

Title

Outcome 1
Objective 1
Procedure 1
Trainee Work 1
Assessment 1

Outcome 2
Objective 2
Procedure 2
Trainee Work 2
Assessment 2

There are 2 of each except for the title and I want the form to eliminate the data chosen in the first combo box from the second one.
i.e: if I choose out 5 in outcome1 I don't want it to appear in outcome 2.

note: the combo boxes are connected to each other for the choice in title determines the outcomes available and the outcomes determine the objectives and the objectives determine the rest

 

[arnelgp]

i have not fully viewed the db, except for your request.
normally there is only 1 outcome field and outcome1 and outcome2 are its records.

 

[qabaselayan]

i have not fully viewed the db, except for your request.
normally there is only 1 outcome field and outcome1 and outcome2 are its records.

Ohmygod thank you so much, can you tell me how you did it?

 

[arnelgp]

see the Row Source of CBout2.

 

[qabaselayan]

see the Row Source of CBout2.

thank you so so much I really appreciate your help

 

[arnelgp]

you're welcome.