MSDE - Applying a filter to a form.

[BlackKnight]

Hi folks,

I want to apply a filter to a form when it opens but in the help it says the filter property is ignored by SQL 7. I tried using the serverfilter property but it crashed Access.

I tried using the access method of docmd.openform "frmname",,,,"WHERE fldname=crteria" which refused to open the form unless I removed the filter argument.

The only solution I have found is to set the recordsource of the form during the form's open event.

Is this the only way? Any help would be appreciated. Yhanx in advance.

Have a good one!
BK

 

[MarkSweetland]

BK,

Don't include the word WHERE in the filter statement on the docmd.openform--just use the valid syntax:

    "frmname",,,,"fldname=crteria"

Mark