dblclick event

[lee123]

hey all i just wanted to ask if anyone knows how to do this, i want to be albe to dbl click in a subform to open up form with the same ID i have did this code but i can't seem to make it work

docmd.openform "joborderf",,,"Customerlsal=" & Customerlsal

or i have tried this:

docmd.openform "joborderf,,,"forms!customerf!customerlsal=" & Customerlsal

and this:

docmd.openform "joborderf",,,"forms!customerf!customerlsal=" & form.customerlsal

i don't understand if this can be done in a subform

lee123

[Stewart Ross]

Hi Lee. The syntax for referring to controls on a subform is Me![subformname].Form![controlname] (see Referring to Items on a Subform in the HowTo section of this forum at http://www.thescripts.com/forum/thread599404.html)

The first example DoCmd you gave was nearest correct. Try changing it to

docmd.openform "joborderf",,,"Customerlsal=" & Me![subformname].Form![Customerlsal]

replacing subformname with the name of your subform.

The criterion string in your second example was not correctly formed, and nor was the reference to the subform control in your third example.

-Stewart

[lee123]

hey thanks for getting back with me on this but the code you gave me to try didn't work. i also tried some of the ones that NeoPa provided on the link you gave me but no luck this is how i entered the code:

DoCmd.OpenForm "JobOrderF", , , "CustomerLsal=" & Me![paidsf].Form![CustomerLsal]

lee123

[NeoPa]

Is your subform in a Tab control?

[NeoPa]

One thing I'd suggest you do :

1. Select the item named [paidsf].
2. Check the Properties pane (Alt-Enter).
3. Does the Properties pane title read "Subform/Subreport: paidsf"?

If NOT, then something's not quite as it should be. Remember, we're not talking about the .SourceObject property here but the .Name one.

Let us know how you get on.