Obtain textbox value from current record in datasheet subform

[Drand]

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

 

[arnelgp]

put this in MyStockNumber ControlSource:

= [FrmInvAddPricesSubForm].[Form]!StockNumber
​

 

[Drand]

Thanks again. That worked really well with what I needed.

Cheers