Obtain textbox value from current record in datasheet subform (1 Viewer)

Drand

Registered User.
Local time
Tomorrow, 04:04
Joined
Jun 8, 2019
Messages
71
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

error reading drive A:
Local time
Tomorrow, 01:04
Joined
May 7, 2009
Messages
11,146
put this in MyStockNumber ControlSource:

= [FrmInvAddPricesSubForm].[Form]!StockNumber
 

Drand

Registered User.
Local time
Tomorrow, 04:04
Joined
Jun 8, 2019
Messages
71
Thanks again. That worked really well with what I needed.

Cheers
 

Users who are viewing this thread

Top Bottom