Hello.

Within a form I've opened a subform. Based upon a click event on this subform I would like to replace this current subform with a new subform. Without using a tab object how might I go about going from 1 subform to another subform? I also don't want to have a subform within a subform.

Form
 |--> Subform 1
 |--> Subform 2


Thank you.

Try the following:

Assume
Main form ==> FrmMain
Subform container in FrmMain ==> subFrmContainer
Sub forms are: subFrm1 and subFrm2
(They are loaded into the subFrmContainer of FrmMain)

================================================== ===============
Inside subFrm1, include a command button "cmdChangeSubForm"
Code for cmdChangeSubForm_Click:

Private Sub cmdChangeSubForm_Click()

'Change frmMain!subFrmContainer.sourceobject to the new sub form
    Me.Parent!subFrmContainer.SourceObject = "subFrm2"

End Sub

================================================== ===============

Hope I am not confusing you.


Scripts82