Calling a procedure in a parent form from a subform

[rls0905]

I am trying to trigger a procedure in a parent form from a procedure in a
subform. I tried to link it to an afterupdate event for an updated textbox
in the parent form, but this didn't work.

 

[Stefan Hoffmann]

hi,

I am trying to trigger a procedure in a parent form from a procedure in a
subform. I tried to link it to an afterupdate event for an updated textbox
in the parent form, but this didn't work.

The procedure itself must be declared as public. Use

Parent.ProcedureName Parameters

to call it.


mfG
--> stefan <--

 

[Stefan Hoffmann]

hi,

The procedure itself must be declared as public. Use

Parent.ProcedureName Parameters

to call it.

Must be

Parent.Form.ProcedureName Parameters


mfG
--> stefan <--

 

[Dirk Goldgar]

hi,


Must be

Parent.Form.ProcedureName Parameters

I think your first version was okay. Have you tested and found
otherwise?

 

[Stefan Hoffmann]

hi Dirk,

I think your first version was okay. Have you tested and found
otherwise?

So both are working.

I find it easier to read code using a continuous scheme.

I'm often using methods with the subform control where i have to specify
the .Form e.g.:

FormRequery SubformCtl.Form

with

Public Function FormRequery(AForm As Access.Form, _
Optional AID As Long = 0 _
) As Boolean

On Local Error Resume Next

Dim ID As Long

If AID = 0 Then
ID = AForm![ID]
Else
ID = AID
End If

AForm.Painting = False
AForm.Requery
With AForm.RecordsetClone
.FindFirst "ID = " & ID
If Not .NoMatch Then
AForm.Bookmark = .Bookmark
End If
End With
AForm.Painting = True

FormRequery = True

End Function


mfG
--> stefan <--