Team - I'm trying to leverage Peter's software (vt) late binding VBA code found at and am having issues implementing it on multiple different Forms with multiple subforms on each. The idea is that when you click on the tab the Source Object is changed from a Dummy form (has no data) to your actual subform.
EDIT to posting: Attached zip of the program I'm trying to leverage and screen captures from my database where I'm trying to implement.
I've put the Class Module (clsVelociTab) directly into my database – didn’t modify it.
I have the frmDummy – didn’t change it.
On each form I used the same code On Open that was in the example database in the link.
My goal is to use this one on open code for every primary form but maybe the Class Module is only built to handle one Form with multiple subforms?
Or you can't run this code with multiple forms open at the same time?
Thoughts?
EDIT to posting: Attached zip of the program I'm trying to leverage and screen captures from my database where I'm trying to implement.
I've put the Class Module (clsVelociTab) directly into my database – didn’t modify it.
I have the frmDummy – didn’t change it.
On each form I used the same code On Open that was in the example database in the link.
My goal is to use this one on open code for every primary form but maybe the Class Module is only built to handle one Form with multiple subforms?
Or you can't run this code with multiple forms open at the same time?
Thoughts?
Attachments
Last edited: