Sub-Form OrderBy

[muppet123]

Hi
I have a sub-form that captures a brief overview of recent telephone conversations. I have ordered it so that recent is shown first as per:

Private Sub Form_Current()
Me.OrderByOn = True
Me.OrderBy = "MailingID DESC"
End Sub

My problem is now I can no longer add a record as it reports that I cannot go to that record, which sort of makes sense as it already has a record there.
Any suggestions/help would be greatfully received.

TIA
Mup'

 

[Knicks]

Instead of using this "on current" technique. Why not base the subform on a query with the sort descending on MailingID.

 

[muppet123]

good idea Knicks, hmm now I'm thinking I should really have thought of that one!

Thanks for the help Knicks