Uneditable datasheet view that won't save Filters

[connie]

Hi,

Users of my database have requested a version of the main table that can be viewed, filtered, and sorted A to Z just like the real table, but an uneditable version.

I've created this via a subform, datasheet view, with Allow Edits, Allow Deletions, and Allow Additions set to "No," Allow Filters set to "Yes" and Record Locks on "No Locks." The Control Box and Navigation options are allowed.

When the user closes out of the form/subform, it does not ask/prompt for a save - which is good, I don't want it to. And when it is reopened, it's in its original state without those filters or sorts that user chose last being applied - also good.

However, in design view, it clearly saves the last Filter under "Filter" on the Data tab, as well as the last Sort under "Order By" on Data table. I have Filter on Load and Order By On Load set to No. Is this ever going to cause a problem, i.e., is there something I'm doing wrong? I don't want it to save anything to the form nor subform at all that the user does with it.

Thanks!

 

[DCrake]

Try:
On the OnLoad event

Me.Filter = ""
Me.FilterOn = False


David

 

[connie]

Try:
On the OnLoad event

Me.Filter = ""
Me.FilterOn = False


David

Thanks, I have tried:

Private Sub Form_Load()
Me.Filter = ""
Me.FilterOn = False
Me.OrderBy = ""
Me.OrderByOn = False
End Sub

However it still saves the last Filter and Order By under those respective categories in the Property Sheet (although it doesn't apply them). Does this have something to do with having "Fetch Defaults" set to yes?
Basically as long as it doesn't affect the main source table at all and doesn't end up randomly saving/reapplying filters or Orders I suppose it's not a huge deal...?

 

[DCrake]

The fact that if you go into the property sheet of the form and filters appear in the section does not imply that these filters are applied when the form is opened.

Or at least that is what I am lead to believe. It is just that this filter was used in the past. I would not worry about it unneccessarily.

David

 

[connie]

Right, like I said it doesn't apply them, just apparently saves them. Well ok if I run into any problems with this (hopefully not!) I'll post it on this thread. Thanks!