CODE:
strValues = "(((dbo_UPR00100MBR.EMPLOYID)='" & Me!txtMNumber & "'))"
DoCmd.OpenReport "YearEndStatement", acViewPreview, , strValues
END CODE:
-------------------------
ERROR:
it says that:
The Specified field 'dbo_UPR00100MBR.EMPLOYID' could refer to more than one table listed in the FROM clause of my Sql Statement.
-------------------------
which it isn't.
It works in my other Access programs that is why it is strange that I am getting this error. Any suggestions?
Attached is my picture of my query.
strValues = "(((dbo_UPR00100MBR.EMPLOYID)='" & Me!txtMNumber & "'))"
DoCmd.OpenReport "YearEndStatement", acViewPreview, , strValues
END CODE:
-------------------------
ERROR:
it says that:
The Specified field 'dbo_UPR00100MBR.EMPLOYID' could refer to more than one table listed in the FROM clause of my Sql Statement.
-------------------------
which it isn't.
It works in my other Access programs that is why it is strange that I am getting this error. Any suggestions?
Attached is my picture of my query.