Help with Syntax for Requery

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

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

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
 
J

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]
 
J

Jeanette Cunningham

Thanks for that John.

Jeanette Cunningham


John W. Vinson said:
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]
 
Top