[AccessD] Filtered combos

Does this object source automation events?  Have you tried a class wrapper?  That might be the way 
to go.  That class could then load the menu data and keep it cached, as well as sinking the events etc.

I have never used the treeview but if it is something that would benefit from a wrapper class I 
might be willing to dive in, to obtain more material for the book.

John W. Colby
www.ColbyConsulting.com


William Hindman wrote:
> ...I use something like that for treeview switchboards to pass an OpenArg 
> stored in the table
> ...caching that table would be useful in that its available to the user at 
> all times and is subject to frequent calls
> 
> William
> 
> --------------------------------------------------
> From: "jwcolby" <jwcolby at colbyconsulting.com>
> Sent: Thursday, March 05, 2009 10:51 AM
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Filtered combos
> 
>> Mike,
>>
>> I can see how this might be advantageous in some processes.  I have never 
>> actually done this before
>> but I have read about the process.  I thought it was more for translating 
>> strings and such, or the
>> ability to use a common string for message boxes, labels and so forth.  I 
>> never really thought of it
>> in terms of holding SQL Strings.
>>
>> Does anyone out there use this technique?  A class to cache these strings 
>> might be useful if you
>> were going to use such a table.
>>
>> If anyone uses it, what kinds of strings do you put in the table?
>>
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> Mike Mattys wrote:
>>> OK, what I was thinking was that you'd have a global class
>>> that is instantiated while the database is open and you'd just
>>> call a method in the class with the record number of the string
>>> that would be the new recordsource of the combo.
>>>
>>> -
>>> Michael R Mattys
>>> MapPoint and Database Dev
>>> www.mattysconsulting.com
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>