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
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