Help needed with form/query

[Sewagerat]

Ok, I'll try to make all this clear. Im not very good at access so pls explain as fully as u can.

I have 4 tables. From them i want to make a query. However, I want to be able to use a form to select which tables will be in the query results and also select the fields that the query uses. E.g. I want the query to display all the fields from Tables 1 and 2, i want to select the criteria using the A.ID, B.ID, C.ID fields.

Im looking for help on how to do this and it would be greatly appreciated

 

[ajetrumpet]

you have to use code to do this and make the query. what you are trying to do is exactly what the query grid offers you. if you could just resort to the query grid instead of trying it in a form, your life would be much easier.

 

[Sewagerat]

Well, I know you have to use code but I dont know how. What you're saying is impractical because I would have to make a million queries to satisfy all possibilities, I dont see another way around it.