Question about Drop down list

[jhoelesmejarda]

Hello everyone,

Just wanted to ask how can I enable this kind of setting, I have a Departments table, the departments table have a sub department, it is connected as, for each department it can have many sub department but sub department can only have one department.

So basically, I have an ADMIN department with ACCOUNTING, GEN AFFAIRS and RECRUITMENT sub department.

What I want to show in my form is, if they select ADMIN in the department field the sub department will only show the values that are connected to ADMIN.

If for example the selected Department have no sub department the drop down list of sub department will show nothing.

I tried to search in google what to do but I guess I do not know the right keyword to get want I needed. TIA

 

[pbaldy]

Sounds like what are commonly called cascading combos:

http://www.baldyweb.com/CascadingCombo.htm

 

[jhoelesmejarda]

Thank you for the reply.

I don't have any idea about that since I am not well verse in access vba not like excel.

But I'll definitely try it for my learning. Thank you very much

 

[pbaldy]

No problem. Post back if you get stuck.