Re: Resort Form based on click

Nothing wrote:
I have a form that displays a list from a query. It lists first name,
last name, bidder number and a check box that shows tax exempt status.

By default the form opens with the data sorted by bidder number. I want
the user to be able to double click the Last Name lable and have the
data re-sort and display in that order with out closing the form.

What is the easiest way to do this?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Open up the property *** for the label. Click on events. If there are no events available, delete the label to disassociate it with the textbox and create a new one.

Then in the OnDoubleClick event do something like
Me.OrderBy = "LastName" 'whatever the field name is
Me.OrderByOn = True
.

Quantcast