enforce chronological order on form

[Ssstacey]

Hi,

I have a form based on a query. In this query I sorted the columns year and month in a chronological order. However, on the form this does not appear that way on the form. How can I enforce this?
Thank you
Stacey

 

[RuralGuy]

Does it seem to be sorted alphabetically instead? If so then look into creating another field in your query using DateSerial() to sort on.

 

[Ssstacey]

Hey..
i did not use the date serial solution... but u were right about the alpgabetical order. I put on a filter and forgot to take it off. Guess the filter is stronger than the order in the query.
Thanx for pointing that out.
Stacey

 

[RuralGuy]

Glad I could help Stacey. Good luck with the rest of the project.