I created a form bound to OrderHeader and put in a SubForm based on OrderDetail, linking by OrderID. I haven't changed a single property since creating the form; I want to get the basic data model working and then I'll go back and customize how everything looks and works.
As it is now, if the user clicks in the subform to sort or filter anything, I get the following error:
Expand|Select|Wrap|Line Numbers
- Syntax error in query expression '[SELECT [OrderDetail].[OrderNumber], [OrderDetail].[LineID], [OrderDetail].[Item], [OrderDetail].[Qty], [OrderDetail].[Price] FROM OrderDetail; ].Order'.
This is in Access 2007.