Advertisement

07.22.2008 at 07:33PM PDT, ID: 23587204
[x]
Attachment Details

What is correct syntax for Requerying subform within subform

Asked by cklosko in Access Forms

I have successfully been able to requery a subform within a form using:
Forms("parentform").subform.form.requery

How is the syntax if another level is added. Parent form_A has a subform_B. Subform_B has subform_C. I have tried using:
Forms("form_A").subform_B.subform_C.form requery
Forms("subform_B").subform_C.form requery
but both of these statements return errors.

What is the syntax for performing a requery on a subform within a subform?

Thanks.Start Free Trial
 
Loading Advertisement...
 
[+][-]07.22.2008 at 08:46PM PDT, ID: 22065821

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Access Forms
Sign Up Now!
Solution Provided By: harfang
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.23.2008 at 11:46AM PDT, ID: 22072519

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628