Setting the serverfilter...

S

SparkG

Am trying to clear the serverfilter and filter in a
form's onclose event with:

me.serverfilter = "" or form.serverfilter = ""

Also trying to set filter with:

me.serverfilter = "" or form.serverfilter = ""

It doesn't seem to work. I present my users with a "list
view" form of all records, then they select one record
and go to a single record view with a

stLinkCriteria = "[Id]=" & Me![Id]
DoCmd.openForm stDocName, , , stLinkCriteria


Sometimes the serverfilter gets "stuck" on an
id and I have to go in design mode and delete it.

Any enlightenment on why this seemingly simple function
doesn't work?
 
S

SparkG

Thanks for the quick comeback John...we're using Access
2002 as a front end SQLServer 2000. I've tried putting
that same code to a button, open in design mode and it
still doesn't do it.

-----Original Message-----
Which version of Access? Access 2002 fixed a lot of bugs in this area in
adps. You should still be able to successfully do:

Me.ServerFilter = ""

and

Me.Filter = ""

... in the form close event.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR? pg=personal&fr_id=1090&px=1434411
SparkG said:
Am trying to clear the serverfilter and filter in a
form's onclose event with:

me.serverfilter = "" or form.serverfilter = ""

Also trying to set filter with:

me.serverfilter = "" or form.serverfilter = ""

It doesn't seem to work. I present my users with a "list
view" form of all records, then they select one record
and go to a single record view with a

stLinkCriteria = "[Id]=" & Me![Id]
DoCmd.openForm stDocName, , , stLinkCriteria


Sometimes the serverfilter gets "stuck" on an
id and I have to go in design mode and delete it.

Any enlightenment on why this seemingly simple function
doesn't work?


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top