Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: pwhite1048
- Order by date
-
Open Form with Matching Data from Separate Form
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...- pwhite1048
- Post #6
- Forum: Microsoft: Access Forms
-
Open Form with Matching Data from Separate Form
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...- pwhite1048
- Post #4
- Forum: Microsoft: Access Forms
-
Open Form with Matching Data from Separate Form
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...- pwhite1048
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
