Filtered Records Wont Stay Filtered

[ortizimo]

I have two options in my DB...InCollection and Wishlist...its for a game collection...anyway, when the page loads its set to InCollection but if I edit a Wishlist item and hit the Save button the entire page gets stuck on Wishlist the next time I open it. I have to click on InCollection then Save to restore it. I have the code below and it does this anyway. Any help is appreciated. Thnx.

Private Sub Form_Load()
DoCmd.SetFilter [InCollection] = True
DoCmd.SetOrderBy "ConsoleName, ASC, Games, ASC"
End Sub



I've also used Me.FilterOn = True and Me.Filter = "InCollection"

[pbaldy]

The filter is a string, so try

Me.Filter = "InCollection = True"
Me.FilterOn = True

I'm assuming that's a Yes/No field.

[Micron]

This might shed some light on why your setting isn't saved https://ss64.com/access/setfilter.html (note 2nd last paragraph before Example).
SetFilter was introduced in 2010 for dealing with web based data AFAIK. It's not for what you're doing.

[ortizimo]

The filter is a string, so try

Me.Filter = "InCollection = True"
Me.FilterOn = True

I'm assuming that's a Yes/No field.

You are a FREAKING GENIUS!!!! it worked! Thanks!

[pbaldy]

I'm a legend...in my own mind.

Glad it worked for you.