assigning value to variable

That is the name of the subform name.

Code:
txPartner = Forms!frmMassInput.fsubMassInput2.Form.CustomerID
works fine
 
works fine
So use it that way
Code:
With Forms!frmMassInput.fsubMassInput2.Form
    txPartner = .CustomerID
    txAmount = .Total
    txCurrency = .currencyX
    txDescription = .TreatmentID
End With
 
THANKS A LOT!!!
Works like charm.
 
Or set an object to the sub form

Code:
dim frm as form
set frm = Forms!frmMassInput.fsubMassInput2.Form
txPartner = frm.CustomerID

Not saying this is better but same result
 

Users who are viewing this thread

Back
Top Bottom