If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|