Refresh method error

[Bretona10]

Hi everyone, I have a problem in a forms Afterupdate code.

The form is three layered, meaning there is a master form, subform, then a
sub-sub form.
I an tryng to refresh the Middle form from the bottom form but this code
"[forms]![master]![Sub].refresh" gives me an error that this cannot be
preformed on this kind of item.
IS there an proper way to refresh the middle form? IS my code wrong? Or cant
it be done?

Thanks
Bret

 

[Cheese_whiz]

Hi Bretona,

If you wanted to refresh a regular subform, the code would look like this:

Forms!subFormControlName.Form.Refresh

You use the subform control name, and you need the .Form after the subform
control name.

See if that helps,
CW

 

[Klatuu]

Try Me.Parent.Form.Refresh