combo box with parent table

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
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
 
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 -
Click to expand...

Thanks millions,
 
Back
Top