Requery/Refresh Subform

[King Kreglo]

I have a main form with a few buttons to select which opens another window where the user orders products from. The main form remains open.
When the order is finished they click submit and the data is appended to a subform on the main table. I can't quite figure out how to get my subform to update.
Here is the code I tryed to use:

Private Sub Command7_Click()
DoCmd.SetWarnings 0
DoCmd.(runs several queries)
DoCmd.Close
DoCmd.OpenForm "frmBegin Order"
Me![Order Central - Access].[frmBegin Order].Requery
 
End Sub

Any help would be appreciated, thanks!

 

[Poppa Smurf]

Use Do.Cmd.Requery "the name of the subform"

 

[King Kreglo]

That isn't doing it for me, I can't figure out why.

 

[Cronk]

In the main form, me.ChildSubformName.form.requery

 

[King Kreglo]

In the main form, me.ChildSubformName.form.requery

I gave that a shot as well, it looked like this:

DoCmd.RunMacro "mcrQryUpdate Order Central Speeds"
DoCmd.OpenForm "frmBegin Order"
Me.[subfrmOrder Central - Access].Form.Requery
End Sub

But I still have to click Refresh after to update the subform.... :banghead:

 

[Cronk]

Which form contains your subform?

The 'Me' operator assumes the subform is in the form whose module the Me is used.

If the subform is in another form then use
Forms!ParentForm.[FONT=&quot].[subfrmOrder Central - Access].Form.Requery

Incidentally, I think it is good practice not to use spaces in the names of not only fields but controls, forms and queries.
[/FONT]