Macro will not sort records

[Triscia]

I have a macro that I based off a query that is sorted in ascending order, but when the macro opens the form it doesn't sort like the query does. Does anyone know what is going on with the Macro. Thanks!

[offie]

How did you make this macro/what is it? WHy dont you just sort you query? In the Design View there is a row called "Sort By", select ascending (if you sort more than one field it will sort the farthest one to the right first and move its way to the left)

If that's not what you want please post more information (code/screen shot etc.)

[Triscia]

I have the query set to sort ascending. When I created the macro I have the Macro to open the Form, with the name of the form in the Form Name, I have the view set to Form and then I put the query name in the Filter Name, but when it opens the form it doesn't sort the records. It opens the records that I need, but they are not sorted. It is weird why it doesn't sort like the query it is based off of.

[offie]

That's werid. I don't normall work with macros, but with VBA, so what is it exactly that you are trying to do? where do you specify this macro to run? How do you want your data in the form? Sounds like it a form issue not a macro issue, when you open the form without the macro is is still not sorted?

[Triscia]

It is very weird. I have the same macro in another database that I copied from this one and the macro works and sorts in ascending order. I am at a loss. It'll pull all the records just won't sort them.

[ItsMe]

I would look at the form's properties and check the Order By property. Make sure it is blank. If it is blank when you first look, try putting something in there to your liking.