[AccessD] Want to repopulate combo after adding items

Bill Benson bensonforums at gmail.com
Wed Sep 10 14:41:59 CDT 2014


What do you mean you added a re query method on that form? I was saying add
lines of code in the event (s) of the pop up sayinf...

On error resume next
Set frmMain = forms (MyMainForm)
On error goto 0
If not frmMain is nothing then
       FrmMain.controls (thecbo).requery
End if
On Sep 10, 2014 3:36 PM, "Susan Harkins" <ssharkins at gmail.com> wrote:

> Right now, yes, there are two forms. The main form is for data entry
> purposes. If the species doesn't exist, the user can click the command
> button to open a form with two fields -- species and common name.
>
> I added a Requery method to the Species combo on the main form thinking
> that it would requery and repopulate the combo box when the user clicked
> the dropdown again -- but it doesn't. It's not even firing the Click event
> that I added. If I could find the right event, I think it would work fine.
>
> Susan H.
>
> On Wed, Sep 10, 2014 at 2:44 PM, Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > I thought you have 2 forms, one to choose species and another to add a
> > species. Isn't your command button to add opening a pop up form?
> >
> > You wrote "The popup form is entering the new species --
> >
> > If so then the one before that I was calling the main form. I assumed
> also
> > that is the form that has the select species combo.
> >
> > You can request that from the popup.
> > On Sep 10, 2014 2:37 PM, "Susan Harkins" <ssharkins at gmail.com> wrote:
> >
> > > Yes, but I'm not sure what you're saying by "call the main form combos"
> > --
> > > I knew that popular was really popup.
> > >
> > > Susan H.
> > >
> > > 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.
> > > > >
> > > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list