[AccessD] Force a dblclick event on a form control

Doh! I figured it out...didn't need to double-click. All I needed to do was
send a space key...
        DoCmd.GoToControl "Asset_Attachment"
        SendKeys " "
Thanx!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Tuesday, May 17, 2011 5:55 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Force a dblclick event on a form control

Thanx to everybody for replying. I'm just responding to the most recent
post.
I have an Attachment control on a form. The control is named
Asset_Attachment. I want the built-in Attachment dialog box to spring open
as soon as I open the form. The only way I know to make that dialog appear
is by dbl-clicking Asset_Attachment. I tried inserting
Asset_Attachment_DblClick (-1) in the Form_Open event but I got a "Sub or
function not defined" compile error.
Is there a way to send those mouse-clicks to the control?
Thx,
Darrell

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, May 17, 2011 2:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Force a dblclick event on a form control

I don't think you can directly make an event stub public.  You would have to
build a public sub 
which called the event stub.

John W. Colby
www.ColbyConsulting.com

On 5/17/2011 5:37 PM, Doug Murphy wrote:
> Maybe I didn't read your question correctly. Do you want to trigger from
> code or on the actual event?  If from code, just put your code in the
event
> stub and then call it from where ever you want by the subroutine name,
e.g.,
> sub controlName_dblClick. If your calling from outside the form you need
to
> make the subroutine public.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
> Sent: Tuesday, May 17, 2011 1:14 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Force a dblclick event on a form control
>
> Anybody know how I could trigger a dbl-click event on a form control?
> Thx,
> -Darrell
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com