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]
 

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
OrderBy property in VBA 8
Form: OrderBy minimum of fields 1
When I set the Orderby to true on my form access crashes by why? 1
Error Message While Exiting Form 5
Detecting orderby 3
OrderBy Expression 1
Setting OrderBy Property to DateDiff() on Report 6

Back
Top