Form Controls - how to link list to selection

[Guest]

Hello,

I need to create a form that allows user to select the Type of Company in a
Combo Box, and based on the selection, the linked Combo Box shows the
corresponding Company Name.

Eg.
1st Combo Box (Type of Company) = Lawyer
2nd Combo Box (Company Name)= ABC Law Firm, McDoe Assoc., etc (if Lawyer is
selected in 1)

Type of Company = Financier
Company Name = Bank A, Bank B, Bank C

For each Type of Company, there is a table that lists all Company Names.

Please advise, I don't know how to create this link/dependency. Thanks!

 

[Allen Browne]

See:
Limit content of combo/list boxes
at:
http://www.mvps.org/access/forms/frm0028.htm

 

[Guest]

Thanks for your reply. I'm new to Access and Programming, so I don't really
understand the article you posted..

Is there a simpler way?