jcampanali
asked on
MS Access 2007 vs 2003 SubForm Event Sequence
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 button on a switchboard to open a form in version 2003, it references the subform's event sequence first(even though rs![Argument] in switchboard routine points to main form The db was built on 2003), and this how I want it to run. However, on 2007 the parent form's Form_Load() Event is fired first which causes problems. Why does the sequence of events called differ from the same exact .mdb between versions 2003/2007?
Thank you
I am opening the same .mdb file on two separate machines. One machine is 2003 version and the other 2007. When I choose a button on a switchboard to open a form in version 2003, it references the subform's event sequence first(even though rs![Argument] in switchboard routine points to main form The db was built on 2003), and this how I want it to run. However, on 2007 the parent form's Form_Load() Event is fired first which causes problems. Why does the sequence of events called differ from the same exact .mdb between versions 2003/2007?
Thank you
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, What I noticed when stepping through on the combo box's After_Update event for form in question(completely by-passing Switchboard) is that the subforms load correctly on 2007 version, however switching from code view to form view shows a superimposed switchboard form(no stops were placed on switchboard). If I run through it in real time, no switchboard form appears, but the sub forms do not populate. I have to re-select from the combo box to populate subform data. After that it's fine as long as the form remains open.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Umm, no because in real time the subform does not populate due the fact that the 2007 version opens main form's events first instead of subform -which is what happens in 2003.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER