Command button to Sort

  • Thread starter Thread starter Keith Ward
  • Start date Start date
K

Keith Ward

Hi,

I have a form with a subform which contains fields I don't want to see but
want to sort by.

I would like to put a command button in the top form which when clicked
sorts the subform by the invisible field by a-z.

How do I achieve this in code?

Thanks

Keith
 
Use this kind of thing in the Event procedure for your command button:

Private Sub cmdSort_Click()
If Me.Dirty Then Me.Dirty = False
Me.OrderBy = "[NameOfYourFieldHere]"
Me.OrderByOn = True
End Sub
 
You must log in or register to reply here.

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

Toggle Button 1
Sorting a form 3
Button to sort a dataview subform 1
Use command button to sort records on a form 2
Command buttons, subforms and data entry 2
TINA-printing a specific record from a subreport 7
Command button turn do visible 2
Subform Data Entry Setting 0

Back
Top