Please help me with Subforms...

[charissav]

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

[Jeff L]

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?
ch*******@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

[Tom van Stiphout]

On 10 Nov 2006 13:03:47 -0800, ch*******@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