• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 609
  • Last Modified:

populate a combo box based upon a selection in another combox box

Attached is the DB

I have a form : SMSItems

I have 2 combo box,
Type and  DEPENDENCY

There is a table: DEPENDENCY
Based on the type selected , I want the DEPENDENCY combo box to populate

I tried many way , couldn't get the corresponding list for the type....
Please advice asap
TESTSMS.accdb
0
mercybthomas74
Asked:
mercybthomas74
1 Solution
 
Jeffrey CoachmanCommented:
Cascading Lists...
Here is one very popular link:
http://fontstuff.com/access/acctut10.htm
0
 
als315Commented:
And this is example, based on your sample. I've also changed fields in table from text to number (normally you should not store text fields, if you can store ID)
TESTSMS.accdb
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now