combo box with parent table

[iccsi]

I have a combo box to let user enter the group name which depends on
the department.

For example the table is following:

tblDept

Dept ID Dept Name
1 Dept 1
2 Dept 2

tblGroup

Dept ID Group ID Group Anme
1 1 D1G1
1 2 D1G2
2 1 D2G1
2 2 D2G2


I use control source the for the group, but it does not have right
drop down and does not show the right group base on the dept.

Your help is great appreciated,

 

[Tom van Stiphout]

On Tue, 10 Feb 2009 10:44:05 -0800 (PST), iccsi <[email protected]>
wrote:

I think what you are looking for is called "cascading dropdowns". You
should not have difficulty finding that term in a search engine.

-Tom.
Microsoft Access MVP

 

[iccsi]

I think what you are looking for is called "cascading dropdowns". You
should not have difficulty finding that term in a search engine.

-Tom.
Microsoft Access MVP







- Show quoted text -

Thanks millions,