I have been working on this ONE issue for over seven hours. I'm on the point of exploding.
My main form has tab controls. Tab1 is a subform, Tab 2 is not, and Tab3 is another subform. When an event occurts on Tab1, I want to requery the subform on Tab3.
I have read and read on this. This should work.
Forms!frmMain.frmTab2.Form
.Requery. (frmTab2 is the container name for the subform.)
Obviously it doesn't work. I have and read on this. On some example I see
Forms!frmMain!frmTab2 and on others I see Forms!formMain.frmTab2. NO ONE gives an explanation why to use . or ! in either case. I have played with every combination I can think of. I won't bore you with the long list of errors.
If you can give me a web site that CLEARLY explains when to use . or ! and why or why not and/or give me code that will work, I'll give every point I can. I am so sick and tired of this.
Start Free Trial
