SubForm Requery (A2K)

[AGMCon]

I know that I

[HansV]

Since you want to update SubForm2, it doesn't make sense to requery SubForm1. Try putting code in the After Update event of SubForm1:

Private Sub Form_AfterUpdate()
Me.Parent!SubForm2.Requery
End Sub

In the above code, SubForm2 must be the name of the subform as a control on the main form. This is not necessarily the same as the name of the subform in the database window.
If it doesn't work, you can try changing the requery line to

Me.Parent!SubForm2.Form.Recalc

[AGMCon]

Hans,

Thanks kindly. As always, right on the button. Seventy-year olds should stop programming when they're still ahead. Almost.