Remove Filter before Search

[Goonynl]

On startup my dbase opens a form, with an automatic filter that filters one
specific record.

What i want to do is that before i press the search button the filter is
canceled, otherwise i will not be able to find any records.

open form command :
DoCmd.OpenForm "Form", , , "[key] = environ('username')"

is there a way not to filter on opening a form, but to simply display a
specific record. (Depending on Who's opening the D-base)

or do i need to use the filter and stop the filter before using a Search.

thanks for any assistance

 

[Goonynl]

On startup my dbase opens a form, with an automatic filter that filters one
specific record.

What i want to do is that before i press the search button the filter is
canceled, otherwise i will not be able to find any records.

open form command :
DoCmd.OpenForm "Form", , , "[key] = environ('username')"

is there a way not to filter on opening a form, but to simply display a
specific record. (Depending on Who's opening the D-base)

or do i need to use the filter and stop the filter before using a Search.

thanks for any assistance

in other words, how do i Easilly kill the filter before starting the seach
(Search is button on Form)