Re: [ADP] What does the Where parameter in OpenForm filter?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Vadim Rapp (vrapp_at_nospam.polyscience.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 15:39:11 -0500

Hello Marshall:
You wrote on Tue, 1 Jun 2004 11:26:20 -0400:

 MS> I've seen a couple of references here and there that indicate that, in
 MS> an Access project, the Where parameter of the OpenForm command applies
 MS> a server-side filter on the data, rather than a client-side filter.
 MS> I haven't seen any official notation on this one way or another.

Indirectly, it's stated in http://support.microsoft.com/?id=296049

 MS> Is this true?

Yes.

 MS> I hope so, as I've been using a combination of passing OpenArgs and
 MS> then declaring the ServerFilter in the Open Event of the form. It's
 MS> awkward, and I'm fairly sure not the cleanest way to handle it.

If the form's recordsource is sql statement, then use docmd.openform,,,<your
criteria>

If form's recordsource is stored procedure with parameters, you specify them
by InputParameters in the form. The criteria in OpenForm is ignored if the
recordsource is stored procedure.

Vadim

Vadim Rapp Consulting
SQL, Access, VB Solutions
847-685-9073
www.vadimrapp.com