By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Resort Form based on click

P: n/a
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 ***
Aug 30 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Aug 30 '06 #2

P: n/a

"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!!!
Aug 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.