Please help me with Subforms...

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • charissav@gmail.com
    #1

    Please help me with Subforms...

    Hi is there anyone out there that can help me with MS Access??? I am
    new to Access and have a project that requires me to create a form with
    a list box of entries, and upon double clicking an entry will pull up a
    subform (hiding the initial form) that gives you data on the entry that
    was clicked in a tab style... I have created the initial form with the
    list of entries and am now stuck on how to create the subform and hide
    it, then pull it up on a double click.

    Thank you in advance for the help!!!
    charissa

    Tags: None
    • Jeff L
      #2
      Re: Please help me with Subforms...

      A subform is a form that appears on your main form. It is not a
      separate form that opens by itself. You can have your subform show
      data that is based on a value you select in your list box. Basically
      what you would need to do is requery the subform after you Double Click
      the value from the listbox using the commad Me.SubformName. Requery

      Do this sound like what you are trying to do?


      charissav@gmail .com wrote:
      Hi is there anyone out there that can help me with MS Access??? I am
      new to Access and have a project that requires me to create a form with
      a list box of entries, and upon double clicking an entry will pull up a
      subform (hiding the initial form) that gives you data on the entry that
      was clicked in a tab style... I have created the initial form with the
      list of entries and am now stuck on how to create the subform and hide
      it, then pull it up on a double click.
      >
      Thank you in advance for the help!!!
      charissa

        Comment

        • Tom van Stiphout
          #3
          Re: Please help me with Subforms...

          On 10 Nov 2006 13:03:47 -0800, charissav@gmail .com wrote:

          "subform" is a very specific object in Access, and from what you're
          describing, it is not what you want. You just want to open another
          form, showing info on the entry that was double-clicked.
          Forms are opened using DoCmd.OpenForm. This method takes a lot of
          arguments; perhaps you can see how to take advantage of that to open
          the second form to just the record you want.

          -Tom.


          >Hi is there anyone out there that can help me with MS Access??? I am
          >new to Access and have a project that requires me to create a form with
          >a list box of entries, and upon double clicking an entry will pull up a
          >subform (hiding the initial form) that gives you data on the entry that
          >was clicked in a tab style... I have created the initial form with the
          >list of entries and am now stuck on how to create the subform and hide
          >it, then pull it up on a double click.
          >
          >Thank you in advance for the help!!!
          >charissa

            Comment

            Previous template Next
            Working...