Is there anyway to let my users sort data on a form?

[chubby]

My problem is, I have to different shops entering gauge cal data. Shop A (day shift) wants the serial number field sorted from low number to high while shop B (night shift) wants the serial number field sorted from high to low number.

My question is, is there anyway to setup the gauge cal form so which ever shop is entering data, they can hit a button to sort the serial number field?

Chubby X-)

 

[tunsarod]

You should study the help file for the OrderBy property,
but why not just display the standard A-Z , Z-A sort buttons in the Forms toolbar.

Rod

 

[chubby]

I'll just put the sort button back in the form tool bar.
I forgot I made a special tool bar for that form.

Thanks