ABDULFATAH
10-24-2001, 10:01 PM
I need to design a continous form with all the names of employees and allowing the user to a detail form of the selected employee bu double clicking the name.
please help me to do it
please help me to do it
|
View Full Version : Auto open form by clicking the name another form ABDULFATAH 10-24-2001, 10:01 PM I need to design a continous form with all the names of employees and allowing the user to a detail form of the selected employee bu double clicking the name. please help me to do it Chris RR 10-25-2001, 04:26 AM In the "on dbl click" property of the name, put code like this: Dim strDocName As String Dim strLinkCriteria As String 'other code might go here... 'set strDocName to the new form strDocName = "fUpdateInfo" 'set up whatever filter you need to bring up this record strLinkCriteria = "[ID_PERSON] = " & Me.ID_PERSON 'Open the new form DoCmd.OpenForm strDocName, , , strLinkCriteria |