select the data in the subform display on my main form text field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mohamedbarkath
    New Member
    • Jan 2013
    • 1

    select the data in the subform display on my main form text field

    MS ACCESS I want to select subform data that data display on my main data text field.I can't able to edit the form.
    Please help me
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    #2
    It is possible to reference the subform control like

    Code:
    Me.[I]subform_name[/I].Form.[I]subform_control[/I]
    It may even be possible to drop the .Form in the middle, but I'm not positive of that.

    You would then be able to make the control on your main form equal the control on your subform.
    Code:
    Me.[I]main_form_control[/I] = Me.[I]subform_name[/I].Form.[I]subform_control[/I]
    Without more information about what exactly your are trying to do, I can't say where to put this code. There are too many options and each would be used in a different circumstance.

    Comment

    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501

      #3
      Mohamedbarkath:
      Your question as worded really is very vague... I almost deleted it for lack of detail and clarity.

      However, thru the magic of my super-secret-decoder-ring: It sounds like you need to refer to the parent form's control.

      The solution for referring to parent form controls is quite simple; however, we normally require that you post your work first.

      What doesn't make sense is your generic comment about not being able to edit the form(s)? I can only guess that you mean that what you've tried doesn't work with the implication that you'd like some help - hence the need to see your work. It helps us help you in that the Experts get a sense of how much you know; thus, how to approach the question.

      Please read: Before Posting (VBA or SQL) Code then post your work.

      Comment

      • zmbd
        Recognized Expert Moderator Expert
        • Mar 2012
        • 5501

        #4
        Cross posted with Seth:

        @Seth: You've taken a great leap of faith and your offered solutions are along the same path I would have taken; however, as you note, OP hasn't provided enough information. Rather than play 20 questions with OP let's await OP's reply for my request for information.

        Comment

        Working...