access 2007 form help

[Tom]

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:[email protected]
Thanks

 

[Mike Painter]

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.

 

[Linq Adams via AccessMonster.com]

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)

 

[Tom]

Mike you are a lifesaver ...that was the exact problem. i can't tell you how
much I appreciate the help!

Tom Fries

 

[Tom]

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