Requery of subform data

[Evans2]

Hi all,

I've got a procedure called ViewOutboundSamples that when double clicked will open my form called frmOutboundSampleEntry Within that form, I've got a subform called sfrmSampleEntryBox. I would like to requery that subform whenever the main form is opened to display any change in data. My attempts below have failed so far. Everything works without the requery bit.

Any help with my syntax is appreciated. Thank you.

Attempt 1:

Private Sub ViewOutboundSamples()



DoCmd.OpenForm "frmOutboundSampleEntry", , , , , acHidden
Forms!frmOutboundSampleEntry.RecordsetClone.FindFi rst "[SO_ID]=" & Me.SO_ID
Forms!frmOutboundSampleEntry.Bookmark = Forms!frmOutboundSampleEntry.RecordsetClone.Bookma rk
Forms!frmOutboundSampleEntry.Visible = True
Forms!sfrmSampleEntryBox.RequeryEnd Sub

Attempt 2:

Private Sub ViewOutboundSamples()

DoCmd.OpenForm "frmOutboundSampleEntry", , , , , acHidden
Forms!frmOutboundSampleEntry.RecordsetClone.FindFi rst "[SO_ID]=" & Me.SO_ID
Forms!frmOutboundSampleEntry.Bookmark = Forms!frmOutboundSampleEntry.RecordsetClone.Bookma rk
Forms!frmOutboundSampleEntry.Visible = True
Me.sfrmSampleEntryBox.Form.Requery

End Sub

[June7]

Why would you need requery immediately upon opening? Opening is a refresh of the form data.

[davegri]

This is rather odd code. How do you know what's happening on the hidden form?
When you scroll through records in the main form, do the proper related records appear in the subform? If not, is that the problem you are trying to resolve?
Perhaps if you tell us what you are trying to accomplish it would help us make constructive suggestions.
And, where is the below code located?

Private Sub ViewOutboundSamples()