Auto Populate Txt Field

[Andyjones]

I have a form that I need help with the problem is this



I have two team called langley B but each team plays in a different division.

So in the form when I select either langey B team I want the div lable to auto populate to show waht division the team is in. could someone have a look at this and sort this out for me.

Attached File(s) Langley_B_Player_Stats_and_Averages.zip ( 619.82K

[aytee111]

Change the team combo box to include the division name. Then in the AfterUpdate event of the team, add this code:

Me![Division Type]=Me!Combo41.Column(2)