June 2, 2014 at 6:54 am
Hello,
I have adp file connected to ms sql db.
In a form I have an button which opens a report based on id number.
The problem is that some ids doesnt load records to the report.The report is empty.
I use office 2007. Adp fiel was created in older version....
Do you know what is wrong?
Thanks
Button has just set this code.
************************************************************
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Dim stDocName As String
Dim stLinkCriteria As String
stLinkCriteria = "[IDtable]=" & Me![idtable]
stDocName = "report"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
*************************************************************
June 3, 2014 at 4:27 am
Okay , I have solve the problem by myself 🙂
There were wrong set conditions of connections between tables.
Have a nice day!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply