Susan Harkins
ssharkins at gmail.com
Wed Sep 10 17:11:18 CDT 2014
A requery on the combo box control,,not the form. Susan H. On Wed, Sep 10, 2014 at 3:41 PM, Bill Benson <bensonforums at gmail.com> wrote: > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >