Referencing a specific form instance

[johnmidcap]

Good morning. Can someone point me in the correct direction about how to reference a specific form instance in Access 2007.

For example, I have three of the same form opened as instances (i.e. a user is looking up three different customer detail records at the same time). I need the program to update one of these form instances with new information.

Is there any way to do this?

I am applying a different caption to each form instance, here is a sample of the code:


Set frmNewform = New Form_frmAffiliations
frmNewform.lstAffiliations.RowSource = strSQL
frmNewform.txtNo = Me.txtNo
frmNewform.txtName = Me.txtBusName
frmNewform.SetFocus
frmNewform.Caption = Me.txtBusName & " Affiliations "
clnClient.Add Item:=frmNewform, Key:=CStr(frmNewform.hWnd)

I have been searching the web for a while to figure this out, but to no avail.

Thank you.

 

[MajP]

Normally you manage your form in a collection. Then you can call them by name. Here is a demo of two forms added to a collection and then setting properties of each

Dim myFrms As Collection

Public Sub manageFrmInstance()
  Dim frm As Form_Employees
  Set myFrms = New Collection
  Set frm = New Form_Employees
  myFrms.Add frm, "FormA"
  Set frm = New Form_Employees
  myFrms.Add frm, "FormB"
  With myFrms("FormA")
    .Visible = True
    .Detail.BackColor = vbRed
  End With
  With myFrms("FormB")
    .Visible = True
    .Detail.BackColor = vbBlue
  End With
End Sub

 

[MajP]

The collection needs to be at the module level in scope. If it is dimensioned in the procedure then as soon as the procedure finishes it would go out of scope.