Help on Server Filter By form w/ SQL and ADP

[Scott]

I am running into the whole ‘IS NULL', ‘IS NOT NULL' problem when
running my server filter by form on a custom form that I setup. The
tricky thing about it, is that it works for super user access (SQL)
but when I try to use a regular user account, it works only ONCE and
then every time after that it comes up with the ‘IS NULL', ‘IS NOT
NULL' problem.



I cannot find any information on this whatsoever in any qualified
source, and I have asked around on the MS newsgroups but to no avail.



One interesting thing that I did, was that I ran the SQL profiler
while running the server filter by form queries using both super user
and regular user access. For the super user, it makes a SELECT
statement every time I click on the Server Filter By Form button but
with the regular user it only runs this query against the database
once to propagate it's fields for the first time it is run and then it
doesn't query back for each additional time I want to enable the
filter, thus the IS NULL / IS NOT NULL problem arises. Please help.



Thank you so much for your time and help.



Sincerely,



Scott Landes