AutoFill based on combobox choice


G

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
 
Ad

Advertisements

T

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
 
G

Guest

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

Thanks again.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top