Filter 2nd Combobox

[Guest]

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

 

[Guest]

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

You need to set the datasource for the cboSector combo to be a query to the
Sector table instead of the table itself. In that query you need to set the
criteria on the DevisionName Field to be the value in the cboDevision combo, ie:

[Formname].cboDevision

gm

 

[Van T. Dinh]

See The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm

 

[Guest]

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

 

[Guest]

Thanks to everybody for the help

I worked out the problem it works great

Best regards

Hugo

 

[john]