Filtering combo boxes

[neilorourke]

Hi

I need the records in a combo box 'id_contact' to be filtered according to a selection made on another combo box 'id_organisation' from the same table.

Could someone let me know the best way of doing this. I am currently using the following query which returns the contacts from all organisations:

Table: tbl_sti, Field: id_contacts
SELECT DISTINCTROW [id_contacts], [contact_surname] FROM tbl_contacts;

I unsuccessfully tried the following to filter the records returned.

Table: tbl_sti, Field: id_contacts
SELECT DISTINCTROW [id_contacts], [contact_surname] FROM [tbl_contacts] WHERE [tbl_sti]![id_organisation]=[tbl_contacts]![id_organisation];

Cheers

Neil

 

[ColinEssex]

Search for Cascading ComboBoxes

This topic crops up weekly and there are examples in the sample Db section

Col

 

[Crilen007]

I think we need to get a "problem solved" thing for posts, so people don't click on posts that are already solved.