Auto open form by clicking the name another form

ABDULFATAH

Registered User.
Local time
Today, 00:41
Joined
Oct 22, 2001
Messages
11
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
 
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
 

Users who are viewing this thread

Back
Top Bottom