Help with Syntax for Requery

[mattc66 via AccessMonster.com]

What is wrong with my syntax? It says its not found.
Forms![frmGroup]!Form![sfrmCustGroup_C1].Requery

 

[Jeanette Cunningham]

Hi Matt,
the syntax for a subform on a form is like this:

Forms![frmGroup]![Name of subform control]!Form.Requery

if sfrmCustGroup_C1 is the name of the subform inside the subform control,
use the name of the subform control instead.
A form with a subform control is similar to having an image control with a
picture inside it.
The form has a subform control with a subform inside it.

Jeanette Cunningham

 

[John W. Vinson]

Hi Matt,
the syntax for a subform on a form is like this:

Forms![frmGroup]![Name of subform control]!Form.Requery

Almost... actually it should be

Forms![frmGroup]![Name of subform control].Form.Requery

The .Form is a property of the subform control - even though it's also an
object within that control.


John W. Vinson [MVP]

 

[Jeanette Cunningham]

Thanks for that John.

Jeanette Cunningham

Hi Matt,
the syntax for a subform on a form is like this:

Forms![frmGroup]![Name of subform control]!Form.Requery

Almost... actually it should be

Forms![frmGroup]![Name of subform control].Form.Requery

The .Form is a property of the subform control - even though it's also an
object within that control.


John W. Vinson [MVP]