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