Hi all.
I have a form with two lists on it; systems and subsystems. When I click on the system listbox, I want it to filter out just the applicable subsystems in the next listbox.
The table that they are looking up has the systems as column headers with subsystems listed under each. So basically the code SHOULD read something like:
SELECT MTabV.*
FROM MTabV
WHERE (COLUMN HEADS) =[Forms]![MenuTest]![SysField];
Can this be done in SQL?
Thank you in advance,
MJ
I have a form with two lists on it; systems and subsystems. When I click on the system listbox, I want it to filter out just the applicable subsystems in the next listbox.
The table that they are looking up has the systems as column headers with subsystems listed under each. So basically the code SHOULD read something like:
SELECT MTabV.*
FROM MTabV
WHERE (COLUMN HEADS) =[Forms]![MenuTest]![SysField];
Can this be done in SQL?
Thank you in advance,
MJ
