Unanswered: Re: Can't get "Order By" working in subreport
I have a report displays information of a sample. Within that report a subreport that displays all bags info. The problem is the subreport will not display the bags in ascending order. I tried adding ORDER BY in subreport open event by doing that subreport will not open(display). If I remove the ORDER BY the subreport opens up but not in order. I don't see any syntax problem could anyone see or tell why this is not working?
I'm using Access 2000 & SQL Server 2000.
Thanks for your assistance.
Here is my code in subreport open event:
Private Sub Report_Open(Cancel As Integer)
On Error GoTo Err_Report_Open
Dim str As String, bag_num As String
lot_n = 4214
sampling_id = 313
'''displays bags with defective parts