By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,479 Members | 2,239 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,479 IT Pros & Developers. It's quick & easy.

Please help me with Subforms...

P: n/a
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

Nov 10 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 10 '06 #2

P: n/a
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
Nov 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.