Same Subform Needs To Be Open On Multiple Forms

[webuser]

I need to be able to use the same underlying form as a subform on multiple forms. I know that sounds confusing but here is what I mean. Imagine opening up a form, form1 and a subform, subForm1 is displayed there as a subform. Clicking a button on that subform opens up another form, Form2 that also contains a subform, who's undelying source object is also subForm1. I don't know if this makes a difference but Form2 is opened up as a Modal, and both forms (and the subforms contained in them) need to be open at the same time.

I know you can open the same form multiple times using the "As New Form" tecnique but how do you apply it to my situation, i.e with subforms...

Thank you in advance!!!

 

[MichaelRed]

Not sure what the "problem" is. A SUBFORM is just a CONTROL and -like any control- is unique to the instance. You can in fact have the SAME sub form on the main form, and have either the same or different data displayed in the different instances. Each Instance has a rerord source, which may me programatically (dynamically) or by design (Statically) have either differenct recordsources or have other properties altered to present differnt data (an example might easily be one of the methods to 'filter' the records.

In an application I am currently working with, there are actually THREE instances of the same subform all of which show different records from the same recordsource. One has records asigned to a currently selected sub set. A second shows all of the records currently assigned to any / all other subsets. The third shows the records not currently assigned to any subset (free for assignment).

So, as I started ... wheres the beef?





MichaelRed

 

[webuser]

I tried some stuff and it didn't work but perhaps there is a different cause to why it didn't work. I'll take your word for it, especially since you say you have done it, and try it again. Thanks for the input.