Display Filter in Form

[Guest]

I have a form that populates a filter and sends to another form. On the
receiving form I would like to show the user the filter so they know what
they selected. I can get this to work on a report by just making a field
=filter . However in a form this does not seem to work. I have tried
me.filter, filter and I always get #name.

 

[Guest]

Hi, Brian.

Although I'm not sure why the textbox doesn't allow the usage of the
shortcut Me, use the explicit reference to your filter:

=Forms!YourFormName.Filter

Hope that helps.
Sprinksl=

 

[Guest]

Nope that doesn't work either, I still get #name. I have a tabbed interface

 

[Guest]

Hmm.

Do you have subforms on the form? Is it possible the filter is applied to
IT, rather than the form on which you're trying to display the filter? In
which case, to display a subform filter on the main form it would be:

=Forms![YourMainForm]![YourSubform].Form.Filter

Other than this, I can only think for you to carefully check all spelling.
I've tested both my original response and this one. Both displayed the
correct filter.

Hope that helps.
Sprinks

 

[Bob Howard]

Is it really me.filter? I would have used me.form.filter ...

Hmm.

Do you have subforms on the form? Is it possible the filter is applied to
IT, rather than the form on which you're trying to display the filter? In
which case, to display a subform filter on the main form it would be:

=Forms![YourMainForm]![YourSubform].Form.Filter

Other than this, I can only think for you to carefully check all spelling.
I've tested both my original response and this one. Both displayed the
correct filter.

Hope that helps.
Sprinks

Nope that doesn't work either, I still get #name. I have a tabbed interface
on the form, but I have tried putting this in the header, footer or on one of
the tabs and I still get # name