Hi all,
I have a purchase order form with a sub form from a transactions table. The purchase order form had various fields such as employee name (combo box)
order date, delivery date etc.
The sub form has itemName, UnitPrice, QuantityOrdered. These are initial fields for ordering. When an order gets delivered, then the user can come back to the purchase order and fill in these fields on the sub form:
QuantityReceived, QuantityOnHold, ReceivedBy(employee name) and DateReceived.
The problem I am now having is previewing this as a report. The order will preview fine if all columns on the sub form are filled in, but if they are left then nothing will show on the report. The idea behind this is that they only fill in fields up to QuantityOrdered when first ordering the items, then preview the report and email to supplier as an order. The form is useless if you have to fill in all fields because last few field are for when items are delivered.
Hope someone can help me
Thanks in advance
Jordan Turner