Help needed, I am stuck!! Forms/subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three forms. One form with a subform, then I have a subform within the
subform. The problem is I do not have enough space to display all the forms.
Is there a way that I can have the main form with a subform, and then use a
command button on the subform to open the next subform? I have used wizards
to no avail, and I have read different code with no avail. Any help would be
greatly appreciated.
 
Hi,
If you have the standard one to many relationship, it's fairly easy.
Whatever your Master/Child link field is, you'll use that in the WhereCondition argument
of OpenForm.
So, something like this behind your command button:
DoCmd.OpenForm "yourForm",,,"id = " & Me.Id

Just substitute your field and control name.
 
Back
Top