Creating a sort order on a Report/Form

[mikebaldam]

Hi,

I have a form listing a load of addresses and I would like to be able to order these addresses by an order value. Is there a way I can have temporary field from within the form to enter an order value by, just for printing purposes...?

I've tried referring it back to the open form but this just stores 1 value in my txtOrder field, and assigns it to all the entries.

There must be an easy way of doing this.....Please...

Thanks

Mike

 

[John.Woody]

Have a look at this and see if it helps. I origionaly found it in a microsoft sample db.