I have this monster query with 13 tables. Most of them are small. I am trying to call a report from VBA and I always have something pop up and say with an input box "dbo_UPR00500MBR.EMPLOYID" and so I
enter in 1 employee number and it still comes up with everyone else that I didn't need.
strValues = " (dbo_UPR00500MBR.EMPLOYID = '" & Me!txtMNumber & "')"
DoCmd.OpenReport "YearEndStatement", acViewPreview, , strValues
How do I fix it?
John-
enter in 1 employee number and it still comes up with everyone else that I didn't need.
strValues = " (dbo_UPR00500MBR.EMPLOYID = '" & Me!txtMNumber & "')"
DoCmd.OpenReport "YearEndStatement", acViewPreview, , strValues
How do I fix it?
John-