Sort Problem

[Johnny Drama]

I have a query that is sorted in ascending order by date. I created a form with a subform that pulls data from the query; however, when the data is pulled into the form it is no longer sorted by date.

It seems like this should be pretty straightforward but I can't figure it out.

Any thoughts?

Thanks

Access 2003

 

[Galaxiom]

The recordsource property of the form either needs to be the name of the query with the Orfer By or include the Order By in its SQL string.

Otherwise perhaps you have a different OrderBy property set for the Form.

 

[Johnny Drama]

That was it. Thanks!