Can I update all combo boxes on all loaded forms?

Been looking through the forums and learning a lot but don’t see this
particular problem addressed . . .
I am trying to update my combo boxes when new data is added. Usually, the
updates need to happen in a form that is not the current focus. (So that
when the current form closes the other forms will be updated) I can find
all sorts of information on how to do this if I know the specific forms to
update. However, I’ve got a whole lot of forms (50+) with multiple paths to
reach other and I would rather not have to think through every single form
path the user took to get there that I would then need to update when a piece
of data is added. Also, I’ve been running into problems when I do
specifically define the forms to update because if there is more than one way
to get to the form where I am adding data I get an error message that the
other form (the alternate path) isn’t open to update it.

Basically when I add data I would like to be able to call up some sort of
public code that finds all my open forms and then updates everything.

I found this code that uses a pretty interesting approach of bookmarking all
the open forms, and then closing them to reopen again at the bookmarked
record:
http://www.mvps.org/access/forms/frm0056.htm
Unfortunately, this won’t work for me as often users are mid-add when they
have to go to a subform to add linked data. Example: In the middle of
adding a new product they find they also need to add a new package code, so
they click on add a new package, add it, and then (hopefully) come back to
the original screen to find their new package in the combo box.

I was thinking some sort of combination of a function that lists all open
forms and then a function that requeries them all. Found some cool requery
code here from Dirk Goldgar:
http://www.accessmonster.com/Uwe/Forum.aspx/access-formscoding/7363/Need-list-of-all-loaded-forms
But I don’t know how to find and pass through each open form in the code.

Thanks in advance for any ideas you may have. I am pretty new to all this
and basically have a trial and error approach to programming, but I feel like
I am just hitting my head against the wall with this one.

Shauna

.

Relevant Pages

  • Re: Can I update all combo boxes on all loaded forms?
    ... What I do is to create a single function that handles the updating of any combos that are open on screen. ... I found this code that uses a pretty interesting approach of bookmarking all ... adding a new product they find they also need to add a new package code, ... I was thinking some sort of combination of a function that lists all open ...
    (microsoft.public.access.forms)
  • Re: package the right way?
    ... I'm compiling a bunch of notes I have on various plants. ... species, I'll have things listed like scientific name, common name, ... So, is the right approach here to create a new package, say "plants" ... you're following this sort of markup strictly then just about anything ...
    (comp.text.tex)
  • Re: [fw-wiz] Securing a Linux Firewall
    ... > sort of thing is always a pain -regardless- of what your typical machine ... The amount of churn in what is required between Solaris ... Solaris 9 is supposed to be better about package granularity, ... My assertion is that the maintenance cost of maintaining a "minimal" build, ...
    (Firewall-Wizards)
  • Re: Sorting
    ... Wouldn't it be easier to use a software package like Family Tree Maker ... Why do you think you can make Excel sort in a different manner ... you certainly cannot use Excel alone to sort your data. ... need a macro to sort each column twice by creating a text string ...
    (microsoft.public.excel.programming)
  • Re: installing new packages under mactex and texshop
    ... and documentation were not stored in separate places. ... related data into different parts of the directory tree. ... since it knows what sort of object it's looking for. ... every package on the tree. ...
    (comp.text.tex)