<div>
In the OnOpen event of the form, check if property Filter is set to something. If it is, set property FilterOn to False.<br />
<br />
Alos, check the form's property ApplyFilterOnOpen (or similar) is set to False.
</div>


<div>
Thank you Gustav but unfortunately this does not work as me.filter is set with the value of the calling parent frame and not set to &quot;&quot;&nbsp;as requested in the OpenForm &nbsp;where condition. No clue why... any further help would really be appreciated... Cheers Michael
</div>


<div>
The parameters don't set the Filter property - they determine how the recordset of the form should be filtered initially.<br />
<br />
If you wish to pass values to the form - to be used for setting a filter by code in the form - use OpenArgs.
</div>


Michael Paravicini

<div>
&quot;&quot; is not the same as Null.<br />
<br />
Use either a filter or a where clause but not both. &nbsp;Personally, because I use mostly ODBC BE's, I never use filters.
</div>


<div>
Thank you so much for this clarification... Rg Michael
</div>


<div>
You might also want to check the FilterOnOpen property and set it to No.
</div>


<div>
Thanks Dale - willl do! Your help is very much appreciated!
</div>


<div>
<div class="content wysiwyg-content">
I use a Sub to open all forms (for validation purpose). One of the parameters passed is lWhereCond. Now I have the situation where lWhereCond is set to &quot;&quot;&nbsp;and yet when I open the form with <br />
<br />
&nbsp; &nbsp; DoCmd.OpenForm lFrameName, lacFormView, lFiltername, lWhereCond, lDataMode, lWindowMode, lOpenArgs<br />
<br />
where both lFiltername and lWhereCond are set to &quot;&quot;&nbsp;the filter is still set to &quot;Resid=3&quot; in the Load event of the form (this was the previous filter used). &nbsp;I am confused why the filter is not reset to nothing and why it still applies the old filter? I am using a form with a subform. Thank you so much for any explanation. Rg Michael
</div>
</div>


I use a Sub to open all forms (for validation purpose). One of the parameters passed is lWhereCond. Now I have the situation where lWhereCond is set to "" and yet when I open the form with 

    DoCmd.OpenForm lFrameName, lacFormView, lFiltername, lWhereCond, lDataMode, lWindowMode, lOpenArgs

where both lFiltername and lWhereCond are set to "" the filter is still set to "Resid=3" in the Load event of the form (this was the previous filter used).  I am confused why the filter is not reset to nothing and why it still applies the old filter? I am using a form with a subform. Thank you so much for any explanation. Rg Michael

OpenForm does not clear Filter

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.