Form Controls - how to link list to selection

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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?
 
Back
Top