A button alternative to double-clicking a subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jonefer - 28 Nov 2005 21:25 GMT

I have a subform viewed in datasheet display where a user can conveniently
view the details of that record in single-form view (pop-up) by
double-clicking
the subform.

However, some users prefer a button on the main form that they can
single click after selecting a record in the subform

The tricky part is getting the main form to recognize:
1) if anything has been selected in the subform
2) what has been selected

how can I get the following code to recognize the above 2 conditions?
DoCmd.OpenForm "frmDetails", acNormal, , "ID = " &
Form_sbfrm_Tasks_Interface.ID

Also tricky, is that if a routine is written in the 'Click' Event it will
interfere with the 'double-click' event.

I know I saw an example of this somewhere, but I can't seem to find it.

Reply to this Message

Graham Mandeno - 28 Nov 2005 21:53 GMT

Hi Jonefer

I assume you already have some code to handle the DblClick event(s) in the
subform.

I suggest you make it a Public function in the subform's module:

Public Function OpenDetailsForm()
DoCmd.OpenForm "frmDetails", acNormal, , "ID=" & ID, _
WindowMode:=acDialog
End Function

Then, for the OnDblClick property of the form/controls, call the function:
=OpenDetailsForm()

And then in the Click event procedure for the button on your main form, call
the subform's function:

Private Sub CmdShowDetails_Click()
Call Me!sbfrm_Tasks_Interface.OpenDetailsForm()
End Sub

Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

>I have a subform viewed in datasheet display where a user can conveniently
> view the details of that record in single-form view (pop-up) by
[quoted text clipped - 16 lines]
>
> I know I saw an example of this somewhere, but I can't seem to find it.

Reply to this Message

jonefer - 28 Nov 2005 23:02 GMT

Thanks, the clean up was nice too.

> Hi Jonefer
>
[quoted text clipped - 37 lines]
> >
> > I know I saw an example of this somewhere, but I can't seem to find it.

Reply to this Message