Form Will Not Order by Selected Field

[JewliaB]

I am creating a database to manage the volunteers in my company have worked. I have two databases, one is their volunteer information. The other database is an "HoursDatabase" where I can input the volunteer's ID number, the date, start time, and end time of each time a volunteer has been working with us. (From here I will calculate their hours volunteered, etc.) These two databases are linked by the "VolunteerIDNumber" field. I have created forms to facilitate the data entry into these two databases. The VolunteerInformation form is working perfectly, but the HoursInformation form is having some issues. I have created a tabular view form where the data can be entered and it appears to work perfectly except it refuses to order by anything other than the volunteer ID number. I would like it to order by date, or at least the "TimeIntervalIDNumber" (the primary key for the database). I would really like to keep these in some sort of chronological order. Please assist.

Thank you in advance,

Jewlia

 

[MStef]

Hello Jawlia!
Look at "DemoSortLA2000.mdb" (attachment, zip).
Open form and try.
I think it is what you need.

 

[Pat Hartman]

Base the form on a query rather than directly on the table. Add an order by clause to the query.

 

[JewliaB]

Thank you all so much. This information was *very* helpful.