Easy Form Question

[B-dub]

I suspect my solution is very simple, but I'm struggling with it. I have a table (tblProjects) containing 3 fields (ProjectID, ProjectName, ProjectSize) which I am viewing on a form. When the user selects the ProjectName via a combo box, I want the corresponding project size to appear in a text box on the form. I've tried using both the Table and a Query as my row source, but I don't get any data in my text box. Sounds very basic! Any thoughts?

[pbaldy]

As long as the row source of the combo includes that field, a textbox with a control source of:

=ComboName.Column(x)

where x is the column number containing the desired value.

[B-dub]

Thank You!

[pbaldy]

Happy to help, and welcome to the site!