Mulitiple combox to filter subquery

[jefbowden]

HELLO,

HERE'S THE SETUP:

TBLMACHINE
TBLSECTION
TBLCOMPONENT

FRM MACSECCOM

I HAVE THE COMBO BOXES ON MY FORM SETUP WHERE ONCE MACHINE IS CHOSEN THAN IT FILTERS THE SECTION THAN SO FORTH FOR THE COMPONENT.

I WANT TO ADD A SUBQUERY FOR MY FORM THAT FILTERS MY INFORMATION AS THE COMBO BOXES ARE SELECTED.

 

[jefbowden]

Unfortuantely i'm at work and the blocked access to that site.

 

[jefbowden]

I was able to open that. So i must do all taht is explained in your instructions or is there extra that i wouldnt need. The problem is i started inputing data and now i'm making changes to the design and trying to preserve the quality of the data. Is there an email where i could to send my data base for u to look at its very sloppy and i need a trained eye to clear out some of my mess

 

[jefbowden]

View attachment Copy of maintenace.zip

please help with setting up a query for my combo boxes that filter once chosen

 

[jefbowden]

If anyone is still out there and could lend me a hand it would be much apppreciated. deadline cutting close and still havent figured it out.