I have a form document to view a datasource. The document has a form, a subform, and a sub-subform, all of them linked with one-to-many relationship. I need to filter the last subform on the fly, pushing a button. I need to write a StarBasic macro that can do that on the fly, without switching to design mode. Is this possible?
Yes given the sturcture looks like the following
+ Form1
+ Form1_1
+ Form1_1_1