How do i open a form from a detailed list by clicking on the ID which functions as a hyperlink?
B Belxaviar1973 Sep 23, 2010 #1 How do i open a form from a detailed list by clicking on the ID which functions as a hyperlink?
A Arvin Meyer Sep 27, 2010 #2 Don't use a hyperlink. Just use straight code: DoCmd.OpenForm, Me.lstFormNames, , , "ID=" & Me.txtID -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access Co-author: "Access Solutions", published by Wiley
Don't use a hyperlink. Just use straight code: DoCmd.OpenForm, Me.lstFormNames, , , "ID=" & Me.txtID -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access Co-author: "Access Solutions", published by Wiley