Anyone know how would you go about refreshing a subform?
Printable View
Anyone know how would you go about refreshing a subform?
Subformname.Requery
For my purposes, I carry out the following to refresh the form without it being a subform:
me refers to the form Observation
VB Code:
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:
VB Code:
Forms("Observation").RecordsetClone.Requery
Can you do it thru the subform itself, if so how?
Thanks Static,
but is there a way to requery the subform to a set record as shown in my example?
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.
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.
Thanks