Combo Boxes Filtering

[gatsby]

Hello All,

What I am doing now is how to filter my drop down button or combo boxes. first drop down works perfectly fine, but the second and third is not working. i know theres something wrong but i just couldnt fix it. i know theres cascading combo boxes and the Tables should be organize in creating cascading comboboxes but my data are just imported coming from an Excel. its a weekly report that is live meaning changeable every week. but number of columns are fixed as well as the name per columns. is there any code that i should place in every combo boxes? or aything i should know and should do?

any help is highly appreciated.

attached is my database....

[June7]

Review http://www.datapigtechnologies.com/f...combobox2.html

Dependent combobox needs a parameterized query as RowSource.

I don't understand why you would requery lkpModule after selecting item in lkpHStatus. Which combobox should be dependent on which other combobox?

Discipline and Module tables have no relationship. If you want Module combobox to be dependent on Discipline, have to use tblHRMS as the source of items for the Module combobox.

SELECT DISTINCT Module FROM tblHRMS WHERE Discipline = lkpAssembly;

As I noted in your other thread, no need to complicate this with a subform. Set the RecordSource for HRMS form and put the bound textboxes directly on it. Move the listbox into form header.

You have ModID autonumber field set as the primary key but you are saving the text from Module field into tblHRMS. Since ModID is not used it is not needed, Module should be designated the primary key field. Discipline table doesn't even have a primary key designated. Nothing prevents duplicates. In fact, the DiscID field is set as Index Yes (Duplicates OK). Why would there be duplicates allowed?