I have an unbound field on a continuous form that i would like to use
the "right click" filter features on. for some reason the fields that
are unbound are not able to be filtered like this. is there a way
around this problem?

tks

What would this filter mean?

If the control is unbound (i.e. ControlSource property is blank), it is a
value that is not related to any field, and so there is no field to filter.

If the control is bound to an expression, e.g.:
=[a] + [b]
you could create a query based on the table that feeds your form. In the
Field row in query design, enter the same expression. Set the form's
RecordSource to the name of this query. Change the Control Source of the
text box to the name of the new field. You now have a field that you can
filter on.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


<fishqqq (AT) hotmail (DOT) com> wrote

On Jul 15, 3:45*am, "Allen Browne" <AllenBro... (AT) SeeSig (DOT) invalid> wrote:
Thanks Allen that works perfectly!