Requery subform after adding record

[RPGguy]

I have a form that displays a subform showing orders. There is a command button on the form to add a record. This button goes to a seperate form to create the record. When returning to the first form the subform doesn't show the new record. I put:
Forms![frmService].[sfmService].Form.Object.Requery

after the OpenForm statement but in debug the above line gets run before I get to the 'add' form.

Thanks for your help.

 

[TRYP]

in code: after the second form inserts the record , add code to requery your calling forms sub Form

i.e.

sub add_record()

'add record code
blah blah blah

Forms![frmService].[sfmService].Form.Object.Requery

end sub