Referring to a Subform
Hello,
I have an order entry form that I am trying to populate two fields from a Company form and the subform Contacts. The problem comes up when I try to refer to the subform field to populate the order entry form.
The main form is frmCompanyAccount and the main field is numAccountID.
The subform is frmCompanyContact and the main field is numContactID.
The first statement works:
[numAccountID]= [forms]![frmCompanyAccount]![numAccountID]
The following statements do not:
[numContactID]= [forms]![frmCompanyContact]![numContactID]
or
[numContactID]= [forms]![frmCompanyAccount]![frmCompanyContact]![numContactID]
Any help would be appreciated.
|