[AccessD] Finders problem

Arthur Fuller fuller.artful at gmail.com
Wed Jul 16 17:14:42 CDT 2008


Thanks. I'll try that right now.

Arthur

On Wed, Jul 16, 2008 at 7:09 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> I think you've answered your own question.
> That's pretty much how I would do it.
>
> A couple of wrinkles:
> I wouldn't  save the original in the Tag,  (gets a bit tricky with two
> lists) I'd use a couple of
> variables that are intialised when the form opens.
>
> You will need to parse me.Filter to get the two appropriate filters for the
> combos.
>
> WHne the QBF is applied it would be something like (aircode):
>
> strFilter =  left$(me.filter, instr(me.filter," AND ")) & ")"
> SiteName.RowSource = strSiteNameRowSource & " WHERE " & strFilter
> SiteName.requery
> strFilter = "(" & mid$(me.filter, instr(me.filter," AND ") + 5 )
> SiteNum.ROwSource = strSiteNumRowSource & " WHERE " & strFilter
> SiteNum.requery
>
> (Note the extra braces  at the start end of the first part and the start of
> the second part) :-0
>
> --
> Stuart
>
>
>



More information about the AccessD mailing list