This is the code I extracted from one of the subforms which works correcly.
lngResult = Me.Parent.UpdateDASubform()
Me.Parent![DASub].Requery
What is the correct syntax to call this function from the update module?
I have tried this which doesn't work:
lngResult = Form!DAMaster.UpdateDASubform()
frm!DASub.Requery
Try
Form_FormName.SubName
change the FormName and SubName to your objects names

Signature
Good Luck
BS"D
> This is the code I extracted from one of the subforms which works correcly.
> lngResult = Me.Parent.UpdateDASubform()
[quoted text clipped - 4 lines]
> lngResult = Form!DAMaster.UpdateDASubform()
> frm!DASub.Requery
Al - 24 Sep 2007 18:24 GMT
Thanks that worked.
The commands now are:
lngResult = Form_DAMaster.UpdateDASubform()
frm!DASub.Requery
> Try
>
[quoted text clipped - 10 lines]
> > lngResult = Form!DAMaster.UpdateDASubform()
> > frm!DASub.Requery