[RESOLVED] Refresh a subform

[whiteWay]

Anyone know how would you go about refreshing a subform?

[Static]

Subformname.Requery

[whiteWay]

For my purposes, I carry out the following to refresh the form without it being a subform:

me refers to the form Observation

Me.RecordsetClone.Requery
    Me.RecordsetClone.MoveFirst
    If Not Me.RecordsetClone.EOF Then
        Me.RecordsetClone.FindFirst "[ID] = " & getCurrentID
        Me.Bookmark = Me.RecordsetClone.Bookmark
    End If

If this form is nested or a subform of the other, I tried this but to no avail because it cannot find the observation form:

Forms("Observation").RecordsetClone.Requery

Can you do it thru the subform itself, if so how?

[whiteWay]

Thanks Static,

but is there a way to requery the subform to a set record as shown in my example?

[whiteWay]

Hangon, I missed the form property in the control object. Looks like I can do it. The form property is a reference to the subform.

[Static]

yes.. u can set all the subform properties from the mainform... like any other object on the form.

hitting items ON the subform requires you to go to the design view of the subform to code it.

[whiteWay]

Thanks