My CR connect to a table called Report_table. I let user to choose order, then

I open a recordset and load data to Report_table and use vb6 code to run report.

I got everything right except: when I run CR first time, I got report in random order(not the order user selected). I close it and select the same thing. THis time I got everything right(in order).
What could be the problem?

Thanks a lot.