Hi
Would appreciate a bit of help with this. I am trying to determine the value of a field in a datasheet sub form when I click on that item in the form.
To date I have:
MyStockNumber = Forms!frmInventoryAdd!FrmInvAddPricesSubForm!StockNumber
That is not necessarily selecting the current record.
How do I incorporate the currentrecord statement into this?
Many thanks for the assistance.
David
Would appreciate a bit of help with this. I am trying to determine the value of a field in a datasheet sub form when I click on that item in the form.
To date I have:
MyStockNumber = Forms!frmInventoryAdd!FrmInvAddPricesSubForm!StockNumber
That is not necessarily selecting the current record.
How do I incorporate the currentrecord statement into this?
Many thanks for the assistance.
David