vba error after moving access db

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top