How to make the existing form use different query

Hi,

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

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?

Thank you!

Petra


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

On Mon, 7 Jun 2004 15:51:34 -0500, zaskodnik
wrote:

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Thank you! I will do it.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

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

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

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

Any suggestions?

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

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

Thanks!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/