Refresh or Requery a bound form

[hefly]

I have a bound form ordered on DocNo. My form is bound via qry_Docs. If I add a DocNo that is out of sequence, how do I get my form to refresh or requery to display the records in numerical order based on the DocNo?

I have tried both Me.Refresh and Me.Requery in the following event:

Private Sub Form_AfterUpdate()
Me.Refresh
End Sub

Private Sub Form_OnLostFocus()
Me.Refresh
End Sub

Nothing is working.

Thank you!

Hefly

 

[PHV]

HAve you tried to play with Me.OrderBy and Me.OrderByOn ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hefly]

Would you do, Me.OrderBy OnLostFocus() or AfterUpdate()?