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

To fire Double Click event of Subform from Main Form

P: 6
Hi,

I have a subform in datasheet layout embedded in the main form.I want to invoke a procedure on the double click of each record in the subform.Is there a away by which I can fire the double click event of Detail section of the subform from the main form?I can't find this event.

As of now,I am invoking the procedure in the Form_DblClick event of the subform.But this invokes the procedure when I double click on any part of the subform.I want to invoke it only on the double click of records in the subform.Pls help.

I don't want to open the subform in a new window.It is embedded in the main form.

Thanks,
Savita
Sep 5 '07 #1
Share this Question
Share on Google+
4 Replies


Scott Price
Expert 100+
P: 1,384
Hi,

I have a subform in datasheet layout embedded in the main form.I want to invoke a procedure on the double click of each record in the subform.Is there a away by which I can fire the double click event of Detail section of the subform from the main form?I can't find this event.

As of now,I am invoking the procedure in the Form_DblClick event of the subform.But this invokes the procedure when I double click on any part of the subform.I want to invoke it only on the double click of records in the subform.Pls help.

I don't want to open the subform in a new window.It is embedded in the main form.

Thanks,
Savita
Change from datasheet to continuous form view or replace subform with listbox. Datasheet view doesn't accept the double-click on record event.

Regards,
Scott
Sep 5 '07 #2

FishVal
Expert 2.5K+
P: 2,653
Hi,

I have a subform in datasheet layout embedded in the main form.I want to invoke a procedure on the double click of each record in the subform.Is there a away by which I can fire the double click event of Detail section of the subform from the main form?I can't find this event.

As of now,I am invoking the procedure in the Form_DblClick event of the subform.But this invokes the procedure when I double click on any part of the subform.I want to invoke it only on the double click of records in the subform.Pls help.

I don't want to open the subform in a new window.It is embedded in the main form.

Thanks,
Savita
Hi, Savita.

Form_DblClick is a Private procedure.
First you need to declare it as Public. When you may fire it explicitely referencing to subform module.
Expand|Select|Wrap|Line Numbers
  1. Dim intCancel as Integer
  2. Form_<subform name>.Form_DblClick (intCancel)
  3.  
Sep 5 '07 #3

FishVal
Expert 2.5K+
P: 2,653
Oops!

Scott nice to meet you here. ;)
Sep 5 '07 #4

Scott Price
Expert 100+
P: 1,384
Oops!

Scott nice to meet you here. ;)

Never a problem! Another instance of posting at the same time :-)

Regards,
Scott
Sep 5 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.