How to make the existing form use different query

Z

zaskodnik

Hi,

I have great form that works on query called "all orders" (= this quer
shows what is in table "orders"). I have another query (that had th
same columns) called "new orders" (= this query shows only unshippe
orders from table "orders").

The form is used for inputing data to "orders" table, and also fo
searching for data. How can I create a copy of the same form that wil
show only "new orders" query data?

Thank you!

Petr
 
J

John Vinson

The form is used for inputing data to "orders" table, and also for
searching for data. How can I create a copy of the same form that will
show only "new orders" query data?

It's not really necessary to do so; you can instead use the Filter
property of the form to filter the recordsource to display only new
orders, if you wish. If you want a separate form, simply select the
form on the Forms window (without opening it), and Ctrl-C to copy,
Ctrl-V to paste. Rename the form and change its Recordsource property
to the new orders query.
 
Z

zaskodnik

I tried to use "filter by selection" and "filter by form" and if wa
giving me bad results.

How can I filter my data when the criterium for filtering is i
subform? (it is checkbox)
If the "shipped" checkbox is unchecked... I want the line of the PO t
be shown. (as well as info about customer... this is in the mai
form...not subform)

So, when the PO is fully shipped (=all lines of PO have checkbo
checked)and it will not show anything in subform, not even in for
(PO#, customer name).... it will not be viewable.

If PO is partially shipped, it will show everything except shippe
lines.

Any suggestions?

FYI:
The table "orders" has customer name, PO#, date (this is used fo
form)
The table "orderDetails" have productName, QTY, ExtPrice, Shippe
checkbox... etc. (this is used in subform)

"Orders" have one to many relationship with "orderDetails"

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top