R
Rock
I have this code:
Private Sub List49_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "ActiveEEList"
stLinkCriteria = "[EmpID]=" & Me![List49].Column(1)
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
It was working fine until I moved the access db from one path to
another...I had it in MY Docs folder then moved (copied) it to a
network drive. When I run if from the old version it works fine, but
now from the new location I get Run Time Error 3075, Syntax Error
(missing operator) in query expression [EmplID]=
Any ideas?
Private Sub List49_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "ActiveEEList"
stLinkCriteria = "[EmpID]=" & Me![List49].Column(1)
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
It was working fine until I moved the access db from one path to
another...I had it in MY Docs folder then moved (copied) it to a
network drive. When I run if from the old version it works fine, but
now from the new location I get Run Time Error 3075, Syntax Error
(missing operator) in query expression [EmplID]=
Any ideas?