Automatically Remove Filter

[Haynesey]

Hi,

Using the following code, my database automatically open a particular record:

DoCmd.OpenForm "frmPerson", acNormal, , ("PersonID =" & lstOtherHouseholdMembers.Column(6))

This works but filters the recordset so that only that record is available unless you untick the filter button.

Is there a piece of code to automatically remove the filter button that I can add once the record has been selected so that users then can navigate between the other records.

Thansk in advance

Lee

 

[Dennisk]

use DoCmd.ShowAllRecords