stLinkcriteria no longer working (since 2007 upgrade)
We have just upgraded to 2007 and are having a few minor problems. I've seen
similar threads online but can't find the solution exactly for us.
If I open a report then it shows the report with ALL the records.
If I open it with a button with this code, it shows ALL the records:
Dim stDocName As String
stDocName = "rCertificate"
DoCmd.OpenReport stDocName, acPreview
However, the moment I add stLinkcriteria it fails. This used to work under
the old Access but simply won't work now, i.e. NO records show up:
Dim stDocName As String
stDocName = "rCertificate"
stLinkCriteria = "[fIDNumber]='" & Me![fIDNumber] & "'"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
fIDNumber is an alphanumeric string (hence the single quotes around it).
I have no idea what is wrong with it and can only assume that it's due in
part to a change in Access.
|