how can a subform reference the correct instance of parent form?

[MontyBurns]

Hi,

I have a subform (frmSubFiles) with some code which does a recordcount and updates a txtbox on the parent form (frmIFLR).

Private Sub Form_Current()
Dim intIFLRid As Long

If Not IsNull(Forms!frmIFLR.IFLRid) Then
intIFLRid = Forms!frmIFLR.IFLRid
Else:
intIFLRid = 0
End If

Forms!frmIFLR.txtNumOfFiles = DCount("*", _
"tblIFLRtoClient", "IFLRid = " & intIFLRid)

End Sub

This works fine initially, but when I click on a command button on the parent form to open a new instance of itself, the code gets confused.

It doesn't seem to know which instance it should look at. I could use the Public variable which is holding the reference to the new instance of the form to refer to the main form, but then what about the initial instance of the form?

What can I do?

Thanks,
Burns

 

[DonQuichote]

I think a form has a parent property. I'm not exactly sure, but I think

Me.Parent.Name

should return the name of the parent form, for example.

Best regards

 

[MontyBurns]

thanks. Finally found a good article on managing multiple instances of forms. Haven't applied any of it as yet, but it looks like it should help.

http://users.bigpond.net.au/abrowne1/ser-35.html

Burns

 

[PWise]

Me.Parent.Name will return the name of the parent not the instance
I would try some thing like this in my app when I add a new instance of a form it has a separate caption select some unique to the parent and I add a text box called fn to the subform
For co = 0 To 20
If Forms(co).uniqueitem = Me.uniqueitem Then
Forms!subforname!fn = co
Exit For
End If
Next co
and reference it like forms(me!fn).textboxname