Problem with serverFilter

[sophieK]

Hi
i'm developping a new application using an adp project
with MSAccess 2002 and a SQL Server 2000 database.

I open a bound form with the following code :
stLinkCriteria = "[idCommande]=" & Me![idCommande]
DoCmd.OpenForm stDocName, , , stLinkCriteria

I put the following code in th form_close event:
Private Sub Form_Close()
Me.ServerFilter = ""
Me.FilterOn = False
Me.ServerFilterByForm = False
Me.Refresh
End Sub


The problem is the following :
when a user work on the ade file, the filter stay on the last id he has open

Does anyone have a solution.

Thanks in advance for all reply or comments

 

[MarkWright]

Hello sophieK,

I have the same problem and have not had any luck with the things I have tried. I have posted the same thing a couple months ago and never got an answer. Hope you get an answer on this one. This problem is driving me crazy.

Have a nice day
Mark

 

[Nowell]

Hi chaps

I has this problem and I have used the same methods to solve the problem and the only thing I can see that you are not doing is calling.

docmd.save

Try it and let me know!

It is a crap access bug this!

Nowell

 

[yaya013]

Hello

Try

DoCmd.OpenForm "MyFrm", , , stLinkCriteria
Form_MyFrm.ServerFilter = ""

 

[dwight1]

Hi All,

Though this is quiet a old discussion date nov 2003. I am facing the same problem. Does the solution provided here works good or Does any one have the same problem.

I am struggling with this bug for almost a month now. I would appreciate if you can put your thoughts on it.

Thank you

Dwight

 

[dwight1]

Cont..what would be the best way use command while you open the form provided by YAYA013 OR on close event provided by Sophiek.
Thnks