Prev: Help with table design
Next: Preventing Duplicates in a Continuous Form Bound to N:N Join Table
From: fishqqq on 14 Jul 2010 16:11
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
From: Allen Browne on 15 Jul 2010 03:45
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(a)hotmail.com> wrote in message
news:b82aef50-c94e-4fc4-89a5-cd863d7091b1(a)e5g2000yqn.googlegroups.com...
> 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

From: fishqqq on 15 Jul 2010 08:41
On Jul 15, 3:45 am, "Allen Browne" <AllenBro...(a)SeeSig.invalid> wrote:
> 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.
>
> <fish...(a)hotmail.com> wrote in message
>
> news:b82aef50-c94e-4fc4-89a5-cd863d7091b1(a)e5g2000yqn.googlegroups.com...
>
> > 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

Thanks Allen that works perfectly!
 | 
Pages: 1
Prev: Help with table design
Next: Preventing Duplicates in a Continuous Form Bound to N:N Join Table