I did something similar to MaryTee's suggestion, but kept it on the On Dbl Click. It works!
Private Sub BugID_DblClick(Cancel As Integer)
Dim strDocName As String, strLinkCriteria As String
strDocName = "Form2"
strLinkCriteria = "[ID] = Forms![Form1]![ID]"
DoCmd.OpenForm...
TO: PHV
got one where it would come up and ask for the ID
Can you please elaborate this one ?
I took out the WHERE and put in a Filter containing:
select * from Form2
where Form2.ID = Form1.ID
When I double-click on an ID in Form1, I get an Enter Parameter Value dialog asking for Form1.ID...
I have a form on which I want to double-click a value in a field on the form and open a different form and show the matching 'record'.
Form1 contains an ID field where I've placed an On Dbl Click macro to OpenForm, Form name is Form2, Where is [Forms]![Form2]![ID]=[Forms]![Form1]![ID]. When I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.