Sorting TextBoxes

[divemasterfox]

I have 2 text boxes that display data from a table one is date and another is
classID how do I ensure that when the class id is clicked that the dates are
in ascending order? As it is now all the records for each class are given but
the sort is on the students id but I would like it to be Priority class Id
followed by Date, Is this possible?

 

[George Nicholson]

Base your form on a query, not the table directly.

Make your sort preferences part of that query.

HTH,

 

[VOIA]

I had similar problem. I've solved it by replacing table with a query, with
same fields as table has. And in query You can sort by any field.
To convert link from table to query open data form propreties, and in Field
RecordSource click on "..." and Access will ask You: "Do You want to create
a query based on the table?" Click Yes, and You will got query instead of
table.
Vojislav Depalov