How to populate text box based on Combo Box

[maxstead]

I have looked for quite some time, and I know this is simple as I accomplished it years ago (when much younger ;-)

I have a form based on a table call players. I also have a table called teams that contains team names and divisions (only two fields)

On the player form, I have a lookup on a combo box that allows the user to choose a team name for the player in question. What I am trying to do is to have the Division text box auto populate based on the entry in the teams table.

So, an example.....Choose "Magic Muffins" in the drop down list, and I want A Division to auto fill on the form. (both Magic Muffins and A Division are from the team table- not the player table).

I got as far as going to control source, expression builder, then choosing tables, team table and choosing Division. That returns a #Name - becuase (I think) that it does not know the relationship between team name and team division in this form:-)

please help.....

[pbaldy]

Is this what you're trying to do?

BaldyWeb - Autofill

[maxstead]

Yes, that is exactly what I am trying to do - any way to do it without "coding" :-) It's been a long time! I am using 2007 if that helps any.

[pbaldy]

Well, the method to display the related value doesn't require code.