TheSearcher
Registered User.
- Local time
- Today, 18:54
- Joined
- Jul 21, 2011
- Messages
- 342
I have a report which has a query as its recordsource. The query sorts the "Task_No" field in ascending order. The query works fine but when the report opens the "Task_No" field is not always sorted properly. Sometimes it is and sometimes it isn't. This just started happening after we migrated to Azure O365 (not sure if this is relevant). Below is the code used to open the report. Has anyone run into this before?
Code:
Private Sub cmd_ViewNote_Click()
Globals.glb_TransID = Me.txt_TransID
If Application.CurrentProject.AllReports("N_Note").IsLoaded Then
DoCmd.Close acReport, "N_Note"
End If
DoCmd.OpenReport "N_Note", acViewPreview, , "Trans_ID = " & Globals.glb_TransID, acWindowNormal
Globals.glb_TransID = 0
End Sub