Delete Filter and OrderBy when opening

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

Guest

Is there a way I can delete the Filter and OrderBy properties of my form when
it is opened? Thanks.
 
Is there a way I can delete the Filter and OrderBy properties of my form when
it is opened? Thanks.
Click to expand...

VBA code in the Form's Open event. View the form properties, click the
.... icon by the Open event property, and select Code Builer; edit the
SUb and End Sub lines Access gives you to:

Private Sub Form_Open(Cancel as Integer)
Me.Filter = ""
Me.FilterOn = False
Me.OrderBy = ""
End Sub

John W. Vinson[MVP]
 
Back
Top