Help Designing this form

[johnny878]

Attached Image


http://i.imgur.com/Q3MSCUd.png






Basically, I want this....

Step 1: enter inputs that will be used as the criteria in my queries(i have this working and complete)

Step 2: Runs those queries and makes the resulting tables.(have this working and complete)

But then , I want to have Queries built off the resulting tables automatically populate after i run the macro in step two and have the results showing on the right where you see the brand list box.

The issue I am having is that if i have subforms/queries use the table created in stable. It locks the table and prevents me from running step 2 to begin with.

Any help? Better design suggestions welcome.

[June7]

I can't download the image now. You could attach it to post instead of just providing a link.

Why do you have code creating tables? This is usually a bad idea.