Singlelistbox option to input data to textbox

[craigprice]

I have a form with a list box on it that has 4 teams (Team1-4)

Below this list box I have a text box:

"People on shift tonight"

I want to be able to select a team from the listbox and this prepopulate the people on shift box with the names of the colleagues from the team specified, is there a way to do this?

 

[jdraw]

What tables and relationships do you have?

 

[craigprice]

I have a single table, the two fields used would be: 'Peopleonshifttonight' - this is where I want the selected team to go and 'Team' - this is where team 1-4 is selected, I want this selection to input team members names into 'Peopleonshifttonight'