Order By - removing when closing form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I remove a string from the 'Order by' property on a Form's property
sheet when closing a Form wit an event proceedure on the On Close event?

Many thanks.
 
Don't worry about it John. OrderBy is not applied unless you set OrderByOn
as well.

If it really matters that the value is blank next time the form opens, clear
it it the form's Open event:
Me.OrderBy = vbNullString
 
Back
Top