Bill Benson
bensonforums at gmail.com
Wed Sep 10 14:43:06 CDT 2014
And I am not expecting a kiss because maybe I misread your requirement or environment but the method I suggested works. On Sep 10, 2014 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 >> >