Delete Filter and OrderBy when opening

A

Alex

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

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort in VB using a ComboBox Column Other than the Bound Column 4
Detect OrderBy error in Access97? 0
When I set the Orderby to true on my form access crashes by why? 1
OrderBy empty on ApplyFilter event 0
Error Message While Exiting Form 5
OrderBy property in VBA 8
OrderBy Expression 1
OrderBy property disappearance 1

Top