How can I avoid this? I joined 2 tables with an auto lookup query, fields as
follows:

Products Table:
-Item # (Primary Key)
-Item Description
-Product Line
-Unit Price

Orders Table:
-Order # (Primary key)
-Sortcode
-Item #
-Quantity
-Presenter #

Item Lookup Query:
-Item # (Orders Table)
-Item Description (Products Table)
-Product Line (Products Table)
-Unit Price (Products Table)

The Item Lookup query runs perfectly. I then create a subform for the orders
which includes the following fields:

Orders Subform
-Sortcode (Orders Table and Child field)
-Presenter # (Orders Table)
-Item # (Query)
-Item Description (Query)
-Unit Price (Query)
-Quantity (Orders Table)
-Extended Price (Calculated Control)

In Subform Footer:
Grand Total for Workshop (This field is linked to a calculated control on
the main form.)

This is where it all goes wrong...the query works by itself and the orders
form works by itself, as soon as I combine them it quits working......sooooo
annoying :)

Thanks for your help!