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.

If the subform is showing all orders for a particular customer, wouldn't the master/child relationship be the Customer ID in both tables, not the Order ID?

Cheers,
SteveA