[AccessD] Want to repopulate combo after adding items

Did u read next post?
On Sep 10, 2014 1:49 PM, "Susan Harkins" <ssharkins at gmail.com> wrote:

> > Susan, call the main forms combos  re query right after popular adds the
> > new species.
>
>
> ==========I'm not sure what you meant by this.
>
>
>
> > Optionally (depends on your workflow) u can also set the list
> > index (perhaps value for a cbo) to the just added item as well. I usually
> > loop forms to make sure that main form is still open, since sometimes
> > species are being added as standalone.
> >
>
> ==========This is a great idea because the user would only add a new
> species at this point if that species defined the new animals s/he's
> adding. A nice touch. I should've thought of it myself.
>
> >
> > This is one of the things I like about access, that a pop up still can
> get
> > a handle on the previous form.
> >
> > You can even loop all forms looking for all controls that use species in
> > their rowsource, and requery them all at the same time (possibly setting
> to
> > their previous values after re query if that happens to deselect user
> > selections ...
>
>
> ==========I hadn't considered requerying the main form from the popup --
> good thought too.
>
>
> > I can't remember if requery does so). Probably wouldn't hurt
> > to prompt the user after the popup, on close, if more than one species
> were
> > added or change, versus only 1, before changing control values. If only
> 1,
> > they probably were adding as a part of the other forms workflow. If they
> > added 2 or more, you wouldn't know for sure they wanted to alter the item
> > showing in the other control, you only know they wanted to increase the
> > population.
> >
>
> ==========it would only be one.
>
> Thanks!
>
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>