Sort Button

[Mark]

I am trying to program a button in vba that performs a
sort on multiple fields. For instance, "Rank"
then "Name".

I have tried every combination of OrderBy that I can
think of. Is that the correct command?

Thanks

 

[Larry Linson]

_What_ are you trying to sort? Data displayed in a Form? Data in a Query?

If you are trying to sort data in a Table itself, that won't work --
relational database tables are, by definition, unordered.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks for responding Larry,

Yes, I am trying to program a few buttons that will sort
records on more than one field in a continuous form. Do
I need to base the form on a query, or does that matter?

Thanks again,

Mark

 

[Guest]

Hey,

I got it worked out.
I didn't know about the Form.OrderByOn = True

Thanks,

Mark