Access Form Requery

[ntaylor]

I have a main form with 3 subforms that I am using

DoCmd.Requery "SubformName"

For each of them. This works fine as long as the main form has the focus. If
it does not have the focus then the I get Runtime Error 2109 Stating that
"SubformName" does not exist in the current field.

I really do not want to force the focus to the mainform because an operator
may be entering in one of the subforms when it executes the requery because
it is set on the form timer.

Is there a different command that will allow all of the forms to Requery
reguardless which form has focus?

Thanks

 

[tina]

try

Forms!MainFormName!SubformControlName.Form.Requery

hth