I have made a query for each column in my table in order to sort by ascending order. I want to assign this Query to a column heading button on my form. What is the code, or how do I go about assiging this query to this button so every time it is clicked the data is sorted according to what that query says. This would be similar to sorting your e-mail account by clicking the header and it changing the order of mail by ascending order.

I am new at this, so if you could please include the code as well that would be very helpful.

list box = listbox73
command button = command43
query name = events location, tied to the events table

Hiya,

   Here is what I did: I created a table with thrww columns, ID, Alpha, and Number. I set these values:

ID Alpha Number
1 A 3
2 B 2
3 C 1

Then I created a query that pulled all the fields in this table sorted by Alpha ASC, which sounds like what you did. Query was called "a"

Then I created a form basedon the table, made it a continuous form, and put the Alpha and Number fields in columns, and then put a button at the header over Alpha. I used this code on the Alpha button:

[Forms]![afrm].[RecordSource] = "a"

This changed the recordsource for the form to the query called a where the alpha column was sorted ascending.

I then used this code on the button over the Number column:

[Forms]![afrm].[RecordSource] = "SELECT * FROM Table1 ORDER BY [Num] ASC;"

So this does the same thing without having to call an external query, and did the same thing, it order the number column ASC.

Does this do what you want?



mmcdonal