Sort by three fields and display in form

[derekbrown]

Hello folks,

There must be an easy answer to this! I have searched the forums but have not found what I need to make this work the way I want it to. I have a three part reference field. The records in the form are supposed to be sorted into ascending order Field1 first, then Field2 and finally Field3. The forms RecordSource is a query that brings through the relevant fields from my table. I have the query sorted according to these three fields so that every time I open the database it sorts the way I want it to. What I want to do is have a button that will sort the records into the correct order when the buttion is clicked. I am sure this can be done, but cannot get it to work on more than one field at a time! Any help/ideas would be greatly appreciatted.

Thanks

 

[derekbrown]

Staring me in the face!

Answer was so simple that I completely overlooked it! Simply requeried the form. Code is:

Form_frmData.requery

Happy days!