Quicky

  • Thread starter Thread starter Headache
  • Start date Start date
H

Headache

Does anyone know what is the VBA code to mimic the sort
ascending, sort descending buttons on the Form View
toolbar?
 
OK,

Ideally what you would need to do is to set the Focus to
the field you would like to sort.

i.e

Then use the following code behind a Command Button for
instance and this will toggle the Ascending and Descending:

Static bTitleAscending As Boolean

Me!Title.SetFocus

If Not bTitleAscending Then
DoCmd.RunCommand acCmdSortAscending
bTitleAscending = True
Else
DoCmd.RunCommand acCmdSortDescending
bTitleAscending = False
End If

Hope this helps you
Mark
 
Cheers Mark, I'll give that a try!

-----Original Message-----
OK,

Ideally what you would need to do is to set the Focus to
the field you would like to sort.

i.e

Then use the following code behind a Command Button for
instance and this will toggle the Ascending and Descending:

Static bTitleAscending As Boolean

Me!Title.SetFocus

If Not bTitleAscending Then
DoCmd.RunCommand acCmdSortAscending
bTitleAscending = True
Else
DoCmd.RunCommand acCmdSortDescending
bTitleAscending = False
End If

Hope this helps you
Mark

.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to add sort button on form? a>z or z<a 1
code for "filter by selection" button, etc. 4
Why can't I sort on the Column? 18
sort button 2
How do I change the record source of a list box. 2
Sort buttons on a form 8
sort command buttons on forms 9
Sorting Find As You Type Form 1

Back
Top