DoCmd.OpenForm - 2003 vs 2010

[hpl2001]

I have written a program in 2003, and I am testing it in 2010 as some users will have 2003 and some will have 2010. I have a menu button that works in 2003, but not in 2010. The code behind it is:

DoCmd.OpenForm "frmBoxRetrievalParameters", , , , acFormEdit

I have another similar button that DOES work, with this code:

DoCmd.OpenForm "frmDCLParameters", , , , acFormEdit

The only difference I can see between the two forms being opened is that the first is attached to a table, and the second is not. When I push the first button in 2010 nothing happens at all. I do not get any error messages.

Any idea why this might be happening?

TIA

Holly

 

[missinglinq]

Sorry, but your explanation has confused me! What happens when you press the second button in 2010? Does any code execute in 2010? To allow Code to run in 2007/2010 you need to declare the Folder that contains the file as 'Trusted.'

To trust your folder, click:

[ol 1]
[li]Office Button (top left)[/li]
[li]Access Options (bottom of dialog)[/li]
[li]Trust Center (left)[/li]
[li]Trust Center Settings (button) on far right[/li]
[li]Trusted Locations (left)[/li]
[li]Add new location (button)[/li]
[li]Enter Folder Name[/li]
[li]Click on Okay[/li]

[/ol]
Linq ;0)>


The Missinglinq

Richmond, Virginia

The Devil's in the Details!