Bill Benson
bensonforums at gmail.com
Thu Mar 13 09:00:01 CDT 2014
That was the parent control' requery, not parent company. Darned finance / VBA cross breeding. On Mar 13, 2014 9:58 AM, "Bill Benson" <bensonforums at gmail.com> wrote: > I guess IF you know which list box goes with each class but if you write > code that takes care of that, you may as well let Access give you the > event handler (of the child) and trigger it by writing childlist.requery in > the parent company's re query event; the way you propose you still need at > least one line of code (probably 2 or more) declaring the variable, setting > it equal to the class, then adding to the publicly declared collection for > persistence, plus you've got the wrapper code. > > I dunno, guess I will take your word this is better, more efficient, or > more readable/fun. Having done both I take Access straightforward code in > Access, although lots of people do like class midules. >