Cascading List

[balexa5701]

Good morning,



I am a local military training manager for a unit within my hospital. I am trying to build an employee for with a cascading list. I am new to Access and I am stumped on how to do this. I have looked up how to do so, without a lot of luck. Can someone help me write this code and tell me how to put it in the DB?

File Name: DMS Database
Form Name: Employee Data

Parent Field Name: Department of_:Label; Caption: Department of
Parent List name: ListDepartment; Control Source: Department of, Row Source:SELECT [Department].[Department of] FROM Department;

Dependent Field Name: Service_Label; Caption: Service
Dependent List name: ListService; Control Source: Department of, Row Source:SELECT [Department].[Department of] FROM Department;

I appreciate all the help in advance.

[pbaldy]

Is this what you're after?

Baldy-Cascading Combos

[ssanfu]

Welcome to the forum and thank you for your service.


Since you are new to Access, I offer these suggestions:
--------------------------------------------------------
Use only letters and numbers (exception is the underscore) for object names.
Do not use spaces, punctuation or special characters in object names.
Do not use look up FIELDS, multi-value fields or calculated fields in tables.
Do not begin object names with a number.


Good luck with your project...

[Micron]

Steve, if I may add https://access-programmers.co.uk/for...d.php?t=225837 as suggested reading.
balexa5701: some good advice there. Predicates such as frm, rpt will tell you right away what you are dealing with. Perhaps not necessary for those with a photographic memory, but certainly useful for those who may have to troubleshoot your design or code later! Who knows, that could include you

I have lots of other links that I frequently pass on for beginners if you care to review them.

[orange]

balexa5701,
I note that this is your first post -welcome to the forum. Too often I see people jumping into physical Access without a clear description/specification of what they are trying to support with a database. I'm not suggesting you are doing this, but want to give you some links that may be helpful with your project - in addition to those offered by others.

Here is a thread with some links that will help with database design and planning.

Good luck.