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 and then the suborder form doesn't show up after I click ok. If I leave the master and child blank the subform works but of course I get every detailed order line that customer ever had.

I have no idea what the error is talking about!!!! Like I said, I didn't change very much from the Northwind. Some fields were added and deleted (i modified the queries to handle these fields) and the way I handle products is different. Please help if you can.

BTW, here is the exact error I am getting when I set the child and master fields to OrderID: "The expression is typed incorrectly, or is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables."

Thank you!