S
stfcTerryA
Hi
I have a form called PurchaseOrders and a subform called POItems
subform POitems is bound to fields in a table
POItemID - Autonumber (Hidden)
POID - link from PurchaseOrderID (Hidden)
LineItem - Number - The field i wish to autonumber
Component - Text
Qty - Number
Price - Number
SubTotal - Number (qty * price)
What i'm trying to do is in the subform generate my own autonumber for the
line item, as in for every PO it restarts from 1 (default value) then as i
select another component it automatically adds 1 to the previous line item.
For example:
1, 12K Resistor, 100, £0.12, £12.00
2, 10K Resistor, 50, £0.15, £7.50
So when i select the 10K Resistor the after update populates the line item
with "2"
Cheers
Terry
I have a form called PurchaseOrders and a subform called POItems
subform POitems is bound to fields in a table
POItemID - Autonumber (Hidden)
POID - link from PurchaseOrderID (Hidden)
LineItem - Number - The field i wish to autonumber
Component - Text
Qty - Number
Price - Number
SubTotal - Number (qty * price)
What i'm trying to do is in the subform generate my own autonumber for the
line item, as in for every PO it restarts from 1 (default value) then as i
select another component it automatically adds 1 to the previous line item.
For example:
1, 12K Resistor, 100, £0.12, £12.00
2, 10K Resistor, 50, £0.15, £7.50
So when i select the 10K Resistor the after update populates the line item
with "2"
Cheers
Terry