Same Form, different base query

[Goodge12]

Hi all,



I've got 9 queries that all pull the same fields from the same table. The only difference is the criteria of the queries.

I made a form based on the first query. Is there a way I can just copy the form and then change the dependency to the second query (and so on and so on)?

I'd rather not re-create each form.

Thanks!

[llkhoutx]

What are you doing, it sounds unnecessarily convoluted? How do you specify the filter?

You can modify the filter of one form to display different data views.

[Goodge12]

I have 9 warehouses that each need their own form as a workflow tool. There is one base table that houses all the data. The queries pull only non-finished workflow for one particular warehouse.

[Goodge12]

Actually, I did some more digging and I think I found the answer...

http://office.microsoft.com/en-us/ac...876561033.aspx

Thanks!