show records in subform in reverse order 1

[muppet123]

Hi All,

I have a subform which captures brief conversations with a supplier. It would be helpful if the most recent conversation was visable first instead of the very first conversation created (i.e. record number 1) being displayed which then requires me to press the record navigation button to get to the last record.

Any help with this would be greatly appreciated.

TIA
Mup'

 

[TSIsolutions]

Hi muppet123,

In the Form_OnCurrent of your subform enter following

Me.OrderByOn = True
Me.OrderBy = "ConversationDate DESC"

Hope this helps,
Lawrence

 

[muppet123]

Thanks very much Lawrence I shall give it a try straight away.

cheers
Mup'

 

[muppet123]

Lawrence that worked a treat, thanks very much for your help.

Mup'