Filter 2nd Combobox

H

Hugo

Hi
I want to filter a list that have to appear in a second Combobox depended on
the selection of a first combo box.

I have two tables Devision and Sector

Table Devision have
- Devision ID
- DevisionName

Table Sector have

- SectorID
- SectorName
- DevisionName linked with table Devision

I have a form Sector with two Combo boxes

- cboDevision linked DevisionName in the table Sector
- cboSector that have to give the SectorNames depending on the selection
of cboDevision

How I can do that?

Thanks
 
H

Hugo

Thx for help but this article don't help, when i do like there I have only
faults.
when I select the firstcombo box to field list en the rowsource to my table
sector field devisionName it show only the field list :

- SectorID
- SectorName
- DevisionName

What I can do wrong please?

Any help is welcom I am really in trouble with this probleme.

Thanks

Hugo
 
H

Hugo

Thanks to everybody for the help

I worked out the problem it works great

Best regards

Hugo
 
Top