2003 vs 2007 Form Event Functionality

[bajo71]

Hello,

I am opening the same .mdb file on two separate machines. One machine is 2003 version and the other 2007. When I choose a combo box on a form with a subform in 2003 version, the Private Sub Form_Current() event on the subform fires successfully, however on 2007 version, it will not. I need to re-select from the combo box and THEN it raises the sub form event.

Any ideas why?

Many thanks.........Jake

 

[bajo71]

Let me add one thing:

THere is a switchboard on the db and when I step through the 2007 version, even though I set my breaks to the On_Load event of the form in question, the code window refers to the switchboard code when finished with the event, whereas 2003 does not do this.

 

[bajo71]

OK, what I am noticing is that 2003 calls the subform and all its events, whereas 2007 calls the mainform. I need the functionality in 2003 to be replicated.

 

[missinglinq]

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)

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!