How do I get my form to navigate through records by a certain sort order?

[DeMarcus]

Problem:
I have a table with records that I would like my form to navigate through by date. My table looks like this:

1. 7/2006
2. 4/2006
3. 11/2006
4. 1/2006

When I open my form, it starts at 7/2006 and if I click "Next Record", it goes to 4/2006, and then 11/2006, and then 1/2006.

I would like for the form to open up with 1/2006 and then go to 4/2006 and then to 7/206 and then to 11/2006.

I feel like the answer is obvious, but I'm missing it somehow. I tried setting the form property "Order By", but that didn't work....

 

[antonyx]

make a query with all the fields from that table..

set the date field to ascending or descending (however you want it)

then use form wizard on that query.

 

[DeMarcus]

Thanks. I guess that's one work-around.