Please Help With Cascading Combo Boxes to Autofill Text Boxes

[hlenorem]

Hello,
I have a table, companies, with all the information about each company.

The I created a form that has a set of cascading combo boxes:
Region --> State --> Company

Once the company is selected I'd like to populate some text boxes with information about the company - i.e. contact, # of stores

How can I accomplish this?

Thank You So Much!
-Heather

 

[namliam]

Have your combobox contain all the (hidden) columns that you need.

Then use "Me.YourCombobox.Column(0)" to return your values.
0 would be the first column
1 the second
etc...

Good luck & welcome to AWF