Vehicle Maintenance

Value From a Form
Value From Subform

You don't close a subform separately in this situation. The subform is a form loaded inside a subform control. To replace it, you change the SourceObject property of the subform control on the main form.

From the button on SubformOne, you need to reference the subform control on the parent form. Also, dbtmainform2.frmSubformOne looks like it is trying to reference the form object rather than the subform control.

It should be something like this:

Private Sub Command1_Click()

    Parent!YourSubformControlName.SourceObject = "frmSubFormTwo"

End Sub

Replace YourSubformControlName with the NAME of the subform control on frmMainForm, not necessarily the name of the form currently loaded in it. Those are often different.

To put a value from SubformOne into a control on the main form, use:

Parent!YourMainFormControlName = SomeControlOnSubformOne

Again, use the actual control names. If the main form control is bound to a field, make sure changing it there is what you want, since it will modify the current main-form record.

The important part is that Parent refers to frmMainForm from inside the subform. You don't need Me.SetFocus first.

I've used this technique myself years ago in a survey database I built for a client. The main form contained the general survey information - the person's name, etc. - and I used the subform control as the area for the individual survey questions (or pages of questions). I swapped the SourceObject to move from one page or step to the next, with Next and Previous buttons right on the subforms.

It gave the user a much cleaner wizard-like experience than closing and opening full forms. This would probably make a good TechHelp video. I'll add it to my list.