Setup External Subforms by code (External = Separatet database).

[gerffo]

Hi Everyone,
I am trying to setup programmatically subforms which are in a separate access database (Separate file access). I am doing this from a form which have the functionality of switching subforms. So the parent from is in the database "A" and the subforms are in the database "B", RecordSource is not needed. Normally, when all forms are in the same database, I use the following:

 Me.Subform.SourceObjet = strSubform

but this case is different. Any Ideas?




Thank you


Gerardo

[June7]

As far as I know, forms must be in same file in order to associate. You could maybe programmatically import form, set the subform container SourceObject property. Then programmatically delete the form.