Getting a form to do a Make Table Query that is not an object

[GuernseyGaz]

Hi all, My first post


I have searched many many sites and still not solved.

I am trying to create a very simple form that produces a report.

On the form there are 2 dropdowns one for the Product Group and the other for the Margin. There is a listbox that shows the product codes related to the ProductGroup dropdown. The user must select a Product Group and a Margin he/she can also select none one or many from the listbox. This all works fine, now heres the problem, if the user presses the View button the code runs a query qryMultiSelect but this only shows the information from the Products Table tblProducts.
I have tried to make the qryMultiSelect in to a Make Table Query tblResults but each time the form is used it reverts back to a normal select query.

I need to Make a new table tblResults from the qryMultiSelect query, then create a new query based on the tblResults where I can add the criteria from the Margin Dropdown on the form. Then run a review report.

If I can get the View button working the rest is easy

Looking forward to some replies...

[June7]

Why is there option to open query to view records?

It is not necessary to OpenQuery before OpenReport.

Why have the words 'Product Group' as part of the product group ID - unnecessary repetition?

What would be criteria based on Margin?

Make table should not be necessary. Should be able to structure filter criteria to accommodate all three search controls.