[AccessD] trying to filter a form on a control's value

Yes, but I gave up.
On Dec 26, 2014 10:08 AM, "Charlotte Foust" <charlotte.foust at gmail.com>
wrote:

> Are you setting the Filter On property too?  I seem to recall needing to
> set filter on to False, setting the filter, and then setting filter on to
> True.
>
> Charlotte
>
> On Thu, Dec 25, 2014 at 2:50 PM, Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > I want to filter a form, when a toggle is depressed based on a control
> > value on my form. When that control changes, I want the filter to be
> > applied. I have tried without success to set the filter a myriad of
> > different ways, and whatever I try, the filter is ineffective (returns no
> > records) when I use any of these attempts.
> >
> > I have tried:
> >          Filter = "FKCompanyID= [Forms]!frmOrders![txtWholesalerID]"
> >          Filter = "FKCompanyID= [Forms]!frmOrders!txtWholesalerID"
> >          Filter = "FKCompanyID=
> > [Forms]!frmOrders!Controls("txtWholesalerID")
> >          Filter = "FKCompanyID= [Forms]!frmOrders!cboWholesaler.Column(0)
> >          Filter = "FKWholesalerID=
> > Forms(""frmOrders"").Controls(""cboWholesaler"").Column(0)"
> >          Filter = "FKWholesalerID=
> > Forms(""frmOrders"").Controls(""txtWholesalerID"")"
> >
> > Finally, getting desperate, I tried a UDF GetWholesalerID() which
> returned
> > the value of one of the controls above, and that would work in the
> filter.
> >
> >          Filter = "FKWholesalerID=" & GetWholesaler()
> >
> > The annoyance though, is that I need to call this in the AfterUpdate
> event
> > of the control that drives it, since the function is not volatile - as
> > reference to a control would be on its own.
> >
> > Is there any form of compliant syntax which will allow me to establish a
> > direct dependence between the filter and the referenced control?
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>