ServerFilter

[Jimpappa]

Hi All,

I have an ADP project connected to a SQL Server Backend. This was an
ordinary access database before and converted to an ADP using the "Upsizing
wizard".

The problem I am having is that, I get these weird situations where the form
is using the "ServerFilter" value from the previous invocation. (For
example, if the form was used to display "Record A" and then if its used
again to show "Record B", it would still display the content for Record A)

Please note that the forms are invoked using DoCmd.OpenForm passing the
"Where clause" as one of the parameters.

Where am I going wrong here? How do I fix this please?
Any help is greatly appreciated.

thanks
Suneth

 

[Sylvain Lafontaine]

When you say still display the content for the Record A when invoked for
displaying the Record B, does it also display the Record B or if it is only
the Record A that you can see?

You should also tell us more about what kind of Record Source you are using
for your form (stored procedure, sql string, EXEC statement, etc.), if they
are other parameters running around and if you close the first form before
opening the second instance or if you just hide it or anything else. Maybe
posting a exemple of your code where you make the call to the DoCmd.OpenForm
would be good, too.