Pre-fill list box

[rncarterjm]

I have attached word doc with my intended outcome.
.SQL design.zipSoccerAdminV2_testingV3.zip
I am created a form to enter game schedule and result but I can't seem to figure out how to develop this form to pre-populate a list box based on slected teams. Please see my document for illustration

[June7]

What do you mean by 'pre-populate'? Create the RowSource list for a list or combo box? The RowSource can be a query, SQL statement, or a static list. Creating the RowSource for list or combo box basically the same.

Review
http://datapigtechnologies.com/flash...combobox1.html
http://datapigtechnologies.com/flash...combobox3.html

[rncarterjm]

What do you mean by 'pre-populate'?

by "pre-populate" i mean that when I select team from dropdown list "HomeTeam" a form will appear to the side with players from the "HomeTeam". When the form appears I will enter goals scored by the player in that list.

[June7]

Maybe you need a form/subform arrangement. As for the 'appear', code can set Visible property of the subform container control.

Maybe the box should be on the same form as the team roster. Review: http://datapigtechnologies.com/flash...tomfilter.html