form filter by word in textbox

[awake2424]

Is it possible in Access 2010 to create a textbox (Team) and a textbox (Captain) on a form that auto-fills depending on a key word in the (Data) textbox? The color is the key word.

For Example, if in Data:
The color is Blue Team auto-fills with Team One Captain auto-fills with Chris
The color is Green Team auto-fills with Team Two Captain auto-fills with Juli
The color is Tan Team auto-fills with Team Three Captain auto-fills with David

All of the values for the auto-fill are on (tblList) in separate columns:

Color Team Captain
Blue One Chris
Green Two Juli
Tan Three David

Thank you.

 

[rzw0wr]

I would try a combo box with the team Names.
A subform with the data needed.
Relate the 2 form with the team ID.

Dale