RE: [MS_AccessPros] Double click in subform to open another form

You could start by using the command button wizard to add a button that opens the form. Then change the code to have it called from a function rather than the command button click. Then stick the function into the double click property of each of the controls in the detail section.

Give it a try and come back if you have questions.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: beader59@gmail.com
Date: Fri, 1 Jul 2011 17:00:01 -0600
Subject: [MS_AccessPros] Double click in subform to open another form

I have a subfrom that has 9 columns ( Id, part_number, part_name, etc.). I
would like to be able to double click on any item in any column and have it
open my parts form... I'm guessing I need to use event procedure for the
double click, but am totally lost on how to write the code....

Thanks,

Deb

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/