Resort Form based on click

[Nothing]

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 ***

[salad]

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 sheet 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

[Mike]

"salad" <oi*@vinegar.comwrote in message
news:pl****************@newsread4.news.pas.earthli nk.net...

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 sheet 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

Thanks that worked great!!!