Hello,
I am having real problems understanding why my purchase order form will not preview as a report. Well the form will preview on the report but only after certain fields have been entered.n The form has all the normal fields a PO would have. It has a sub table for different order lines. In the sub table the fields are :
transactionID, transactionTypeID, unitPrice, quantityOrdered, quantityReceived,
dateReceived, receivedBy.
The purchase order will not preview the order onto the report until the last field- receivedBy(combobox) is entered. The problem with that is when ordering, the company will only initially fill out the ordering fields until the order arrives as a delivery, then they will come back to the form and fill out the received fields.
The receivedBy field is a combo box that will show different employee names and looks like this:
SELECT [tblEmployees].[EmployeeID], [tblEmployees].[Forename], [tblEmployees].[Surname] FROM tblEmployees;
The SQL for the report that previews the order looks like this:
SELECT tblPurchaseOrder.*, tblInventoryTransactions.QuantityOrdered, tblInventoryTransactions.UnitPrice, tblStock.ItemName, Nz([tblInventoryTransactions].UnitPrice)*Nz([QuantityOrdered]) AS Subtotal, tblSupplier.CompanyName, tblEmployees.EmployeeID, tblEmployees.Forename, tblEmployees.Surname
FROM tblSupplier INNER JOIN (tblStock INNER JOIN (tblPurchaseOrder INNER JOIN (tblEmployees INNER JOIN tblInventoryTransactions ON tblEmployees.EmployeeID = tblInventoryTransactions.EmployeeID) ON tblPurchaseOrder.PurchaseOrderID = tblInventoryTransactions.PurchasesOrderID) ON tblStock.StockID = tblInventoryTransactions.StockID) ON tblSupplier.SupplierID = tblPurchaseOrder.SupplierID;
Any ideas for help on this will be greatly appreciated and I am sure it is something really small and simple but has been annoying me for a couple of days now.
Thank you