I am trying to create a form which I will use as an Invoice. It uses 3 tables and has a sub form which I call Orderline, in which I can add multiple part numbers and extracts by the part number the price and description from the Parts table and the quantity I enter for the part then using an expression gives a total for the line.
This is the SQL output for the Query:
Code:
SELECT tbl_COrders.OrderNo, tbl_COrders.fkCustomerNo, tbl_COrders.OrderDate, tbl_COrders.PartNo, tbl_COrders.OrderQty, tbl_Customers.CustomerNo, tbl_Customers.CustomerFullName, tbl_Customers.CustomerStreet, tbl_Customers.CustomerCity, tbl_Customers.CustomerRegion, tbl_Customers.CustomerPostCode, tbl_Parts.PartNo, tbl_Parts.Part_Description, tbl_Parts.SalePrice, tbl_OrderLine.LineID, tbl_OrderLine.fkOrderNo, tbl_OrderLine.fkPartNo, tbl_OrderLine.OrderQty, tbl_OrderLine.LineTotal
FROM (tbl_Customers INNER JOIN (tbl_COrders INNER JOIN tbl_Parts ON tbl_COrders.PartNo = tbl_Parts.PartNo) ON tbl_Customers.CustomerNo = tbl_COrders.fkCustomerNo) INNER JOIN tbl_OrderLine ON (tbl_Parts.PartNo = tbl_OrderLine.fkPartNo) AND (tbl_COrders.OrderNo = tbl_OrderLine.fkOrderNo);
When I open this form all I get is the Header and the Footer and just a blank page. No error messages are shown, so I don't know why it does not display the form(s).
Can anyone see why the form items are not being displayed. I have been trying different ideas for hours and can't find the solution.