access 2007 form help Tom 11/18/2008 11:32:03 PM I am using access 2007. I have a combo box named cbo_supplier on a form named frminvoice. I have created a maco named mcr_add_supplier that opens the frmsuppler in add mode. I tied the macro to a dbl click event for the cbo_supplier field in my frminvoice. In 2003 it was easy to go to the ongotfocus event and get any new suppliers to instantly be available in the combo box once I had added them. I used the event procedure in the ongotfocus event for that cbo_supplier. I merely wrote me.cbo_supplier.requery and it worked like a charm. In 2007 I can' t get the combo box to refresh the list once I have added a new supplier. I have to close the form and reopen it before the new supplier appears. Can anyone tell me what has changed in 2007 and what I can do to accomplish the same thing. Please email:sccaafries[ at ]hotmail.com Thanks

Re: access 2007 form help "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 11/19/2008 2:19:01 AM My first guess is that you are not running the program from a trusted location. I'm not familar enough with macros to be any help there, but I have had one, unrelated to your problem, incident wheer cutting and pasting the same Statement fixed a problem. Have you converted to the 2007 format. I know of one "problem", the date picker, in 2007 which looks looks like it would work in 2003 but does not. Try rebuliding the macros. Tom wrote: [Quoted Text] > I am using access 2007. I have a combo box named cbo_supplier on a > form named frminvoice. I have created a maco named mcr_add_supplier > that opens the frmsuppler in add mode. I tied the macro to a dbl > click event for the cbo_supplier field in my frminvoice. In 2003 it > was easy to go to the ongotfocus event and get any new suppliers to > instantly be available in the combo box once I had added them. I > used the event procedure in the ongotfocus event for that > cbo_supplier. I merely wrote me.cbo_supplier.requery and it worked > like a charm. In 2007 I can' t get the combo box to refresh the list > once I have added a new supplier. I have to close the form and reopen > it before the new supplier appears. Can anyone tell me what has > changed in 2007 and what I can do to accomplish the same thing. > Please email:sccaafries[ at ]hotmail.com > Thanks

Re: access 2007 form help "Linq Adams via AccessMonster.com" <u28780[ at ]uwe> 11/19/2008 4:46:31 AM I don't think the problem is in the Macro, but rather, as Mike suggested, in the code behind the double-click event that is executing the Macro. Code does not run in 2007 unless your database resides in a folder that has been declared a “trusted” location. To trust your folder, click: Office Button (top left) Access Options (bottom of dialog) Trust Center (left) Trust Center Settings (button) Trusted Locations (left) Add new location (button) -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com

Re: access 2007 form help Tom 11/19/2008 8:38:02 PM Mike you are a lifesaver ...that was the exact problem. i can't tell you how much I appreciate the help! Tom Fries "Mike Painter" wrote: [Quoted Text] > My first guess is that you are not running the program from a trusted > location. > I'm not familar enough with macros to be any help there, but I have had one, > unrelated to your problem, incident wheer cutting and pasting the same > Statement fixed a problem. > > Have you converted to the 2007 format. I know of one "problem", the date > picker, in 2007 which looks looks like it would work in 2003 but does not. > > Try rebuliding the macros. > > > Tom wrote: > > I am using access 2007. I have a combo box named cbo_supplier on a > > form named frminvoice. I have created a maco named mcr_add_supplier > > that opens the frmsuppler in add mode. I tied the macro to a dbl > > click event for the cbo_supplier field in my frminvoice. In 2003 it > > was easy to go to the ongotfocus event and get any new suppliers to > > instantly be available in the combo box once I had added them. I > > used the event procedure in the ongotfocus event for that > > cbo_supplier. I merely wrote me.cbo_supplier.requery and it worked > > like a charm. In 2007 I can' t get the combo box to refresh the list > > once I have added a new supplier. I have to close the form and reopen > > it before the new supplier appears. Can anyone tell me what has > > changed in 2007 and what I can do to accomplish the same thing. > > Please email:sccaafries[ at ]hotmail.com > > Thanks > > >

Re: access 2007 form help Tom 11/19/2008 8:39:01 PM Thank you so much Linq. That was the exact problem and you two really saved me many hours of frustrtaion. I am very appreciative to you both. Thanks again Tom Fries "Linq Adams via AccessMonster.com" wrote: [Quoted Text] > I don't think the problem is in the Macro, but rather, as Mike suggested, in > the code behind the double-click event that is executing the Macro. Code does > not run in 2007 unless your database resides in a folder that has been > declared a “trusted” location. > > To trust your folder, click: > > Office Button (top left) > Access Options (bottom of dialog) > Trust Center (left) > Trust Center Settings (button) > Trusted Locations (left) > Add new location (button) > > -- > There's ALWAYS more than one way to skin a cat! > > Answers/posts based on Access 2000/2003 > > Message posted via http://www.accessmonster.com > >