Search results for query: *

My query finds all orders for a particular customer and does so successfully. But when I set the child/master to only show the orders by OrderID, I get an error saying my expression is too complex. Does anyone have any ideas? I have hit the proverbial brick wall.

Thanks for your reply. I am rapidly learning the misgivings of Access 2000! As for the re-creating the query. If you mean, have I deleted the references to the subform and the child/master fields, closed and saved the form, then reopened and re-created the references, then yes. Otherwise, I...

I have an Orders Form modeled as closely as I could to the Northwind example. In my subform for detailed orders, when I link the master and child by the orderId, I get a message saying it's too complex and I should assign some things to variables. I get this message when I open the orders form...