Display Filter in Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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=
 
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
 
Is it really me.filter? I would have used me.form.filter ...


Sprinks said:
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

Brian Nordberg said:
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
Click to expand...
Click to expand...
 
Back
Top