• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 612
  • 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 CoachmanMIS LiasonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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