Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 419
  • Last Modified:

How refer to subform field from main form code

I have this code in an onclick event of a checkbox on a main form...

If Me.chkbxGrowDay1Selected = True Then
       Forms!frmPlanted!subfrmReady.txtReadyDate = Me.txtplantdate + Me.txtGrowDaysCalc
    End If

 but it doesn't seem to like the line...

 Forms!frmPlanted!subfrmReady.txtReadyDate = Me.txtplantdate + Me.txtGrowDaysCalc

What is wrong with the syntax?
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
assuming that "subfrmReady" is the name of the subformcontrol


 Forms!frmPlanted!subfrmReady.FORM!txtReadyDate = Me.txtplantdate + Me.txtGrowDaysCalc
0
 
SteveL13Author Commented:
Thanks.  That syntax seems to be ok.  But now a new issue and I can award this solution and ask another question.  Please watch for question titled "How update all records in a subform"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now