Filter values / Combo box

[anoo]

Hi Experts,

How can I have filtered values on second combo box based on first combo box selection?

3 Tables: Employee, Department, Codes. Employee table contains a lookup field of Department.

Structure:
Tom Dept A Code 1, Code 2, Code 3
Dick Dept B Code 4, Code 5, Code 6
Harry Dept C Code 7, Code 8, Code 9

How can a use a combo box for codes on form so that upon selecting Employee Tom filters codes to relevant ones. (Only Code 1, Code 2, and Code 3)

Thank you for your help.

PS: sample file attached.

 

[MarkK]

Hi: This problem is called "cascading combos." If you search this site, or google, those terms, you'll get tons of information.

 

[anoo]

Thank you very much.

 

[anoo]

Can anyone please help me with my sample database?

I want to capture Employee Name, Code, and hours on Time sheet table.

Thanks again. (I googled and couldn't follow along , If I could see it working on my sample, I am sure.... I will get it)

Cheers.

Hi Experts,

How can I have filtered values on second combo box based on first combo box selection?

3 Tables: Employee, Department, Codes. Employee table contains a lookup field of Department.

Structure:
Tom Dept A Code 1, Code 2, Code 3
Dick Dept B Code 4, Code 5, Code 6
Harry Dept C Code 7, Code 8, Code 9

How can a use a combo box for codes on form so that upon selecting Employee Tom filters codes to relevant ones. (Only Code 1, Code 2, and Code 3)

Thank you for your help.

PS: sample file attached.

 

[JHB]

Here is a sample.

 

[anoo]

JHB, Thank you very much.

Grüß aus Aachen, Deutschland

 

[JHB]

Bitte schön.