Sorting A continues Form 1

[miletracker]

I Would Like to create a continues form with multi columns and above Several of the columns buttons would allow the user to sort the form (a z) or (Z A)
Where do I start???? The Form Is Based Off A Query
Thanks Miletracker

 

[RoyVidar]

Hi!

The easiest would be if you could let the users use the A-Z/Z-A buttons in either the form menu, or the righ-click menu, when a column is selected.

Would that be sufficient?

HTH Roy-Vidar

 

[MarkWright]

Hi, what about using buttons ??
make a command button and use (Me.OrderBy = "fieldname&quot for a to z. and (Me.OrderBy = "fieldname desc&quot for z to a.

just a thought

Mark

 

[miletracker]

Guys Have been gone all day Will try Marks Idea in the Morning
thanks for the reply
miletracker

 

[miletracker]

Mark's Idea Works Perfect What I Did is create a combo with field names and 2 buttons (a to z) and (z to a) works great any field can now be sorted
thanks miletracker

 

[MarkWright]

No problem Glad to help

kind regards
Mark