Remove Filter

[Gus]

Hi,

I copy and pasted a form + subforms (in the same database)
and renamed them as the required form layout/info fields
are identical. I have updated all the necessary links to
queries code etc but in the form property box "Filter"
keeps loading automatically with the report.

I have looked through the code and can't find where this
is loading from?

Any help would be appreciated.

Thanks in advance

Gus

 

[Van T. Dinh]

What the "report" got to do with your Form/Subform?

Form's Filter often have the filter string but the filter is not activated
until you set the FilterOn Property to True or applying the filter.

 

[Guest]

The form copied and pasted has retained its link to the
code in the original form. I cant figure out how to break
this link.

I tried deleting the code in the original form and
reopening the new form (this works fine). However when I
return the code to the original form the link is
reastablished.

Gus

 

[Van T. Dinh]

Sorry, I don't follow your description, especially the "report" you
mentioned in the original post.

When you copy a Form, all the code in the Form's Module will also be copied
onto the new Form. If you want to delete / modify the Form, you will need
to open the module that associated with the new Form and delete / modify the
code.