Hiding Results before Filtering

[Mik2045]

Hi,

I'm currently using this: http://www.allenbrowne.com/ser-62.html for a form.

So, at the moment when I open the form all of the records show but I'd like to hide all of that and only show records when I put in search criteria. Is that possible?

If not, is it possible to order the records by the newest records (starting from the top)?

Thanks!

[RuralGuy]

Allen answered that on his page:

If you want the form to open with no results, add these two lines to the Open event procedure of the form:
    Me.Filter = "(False)"
     Me.FilterOn = True
 and add those two lines to cmdReset_Click as well, in place of:
    Me.FilterOn = False

[Mik2045]

Thanks a lot!

I actually just went back to that same page and saw that.

Thanks anyways RuralGuy.

Problem solved!

[RuralGuy]

Excellent! There is always more to learn when you solve it yourself.