AutoFill based on combobox choice

[Guest]

Let me preface this with the fact that I am a complete novice and I therefore
my description of information may be non-normal.

I currently have cascading combo boxes, Combo1 and Combo2.

I would like to have information from a table, tblProjectList, be displayed
on a form dependant upon the choice in Combo2.

Combo2 is a list of Project Names which are located in tblProjectList. I
want the associated ProjectDescription displayed based on the chosen
ProjectName in Combo2.

Any help would be appreciated.

Thanks,

Mike

 

[tina]

include the ProjectDescription field in the RowSource of Combo2. you can
hide the column from showing in the droplist if you want, by setting the
ColumnWidth property of that column to 0". and be sure to change the
ColumnCount property to include the additional field.

add an unbound textbox control to your form. set the control's ControlSource
property as
=Combo2.Column(n)
replace the "n" with the correct column reference. combo box columns are
zero-based, so column 1 is (0), column 2 is (1), etc.

hth

 

[Guest]

Thank you very much. Oh so simple, amazing how the mind will makes things
much more complex than needed.

Thanks again.

 

[tina]

Oh so simple, amazing how the mind will makes things

much more complex than needed.

Thanks again.

you're very welcome