Access VBA subform control
Hi
I am trying to refer to a field called LastName in my subform called frmLicenseeList using frmLicenseeList.Form.LastN
It is nor working
What am I doing wrong?
Thanks
I am trying to refer to a field called LastName in my subform called frmLicenseeList using frmLicenseeList.Form.LastN
It is nor working
What am I doing wrong?
Thanks
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Murray,
Syntax is:
Forms![frmLicenseeList]![<
The control name on the main form may not be one in the same as the subform name. So if your control name was embMySubForm and the subform name was MySubForm, you would have:
Forms![frmLicenseeList]![e
Jim.
Syntax is:
Forms![frmLicenseeList]![<
The control name on the main form may not be one in the same as the subform name. So if your control name was embMySubForm and the subform name was MySubForm, you would have:
Forms![frmLicenseeList]
If it is from code in the main form, it will be:
LastName = Me!NameOfTheSubformControlHoldingFormfrmLicenseeList.Form!LastName.Value
Not to beat this further, but be sure you're using the name of the Subform Control on your form, which may or may not be the same as the form you're using as a Subform. You can determine if you're working with a subform by selecting the control on the form and checking the Property Sheet >> Data tab. If you see a property named "Source Object", you've selected the right control
Premium Content
You need an Expert Office subscription to comment.Start Free Trial