Can't find the field 'frm_Test2" referred in your expression.

B

bsm

Hi,

This question was asked many times and answered too. But none of them
rectify my issue. Plz help me.

In my parent form I have two sub forms. In Button click event of Main
Form I am accessing the Sub Form Control value. But it doesn't work.

Debug.Print Forms!frm_MainForm.Controls!frm_Test2!VS_Type.Value

Where frm_MainForm is the Parent form, frm_Test2 is sub form and
VS_Type is control of the sub form.

It is very urgent.
 
D

Douglas J. Steele

That should be

Forms!frm_MainForm!frm_Test2.Form.VS_Type

(a . before Form, not a !)

Also, make sure that the name of the subform control on frm_MainForm is
actually frm_Test2. Depending on how frm_Test2 was added as a subform, the
name of the subform control may be different than the name of the form being
used as a subform. It's the name of the control you want.
 
G

Guest

Hi Doug,

You are right i will be punishing myself for that one... Thanks for the
correction.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ERROR: "...Can't find the field 'i' referred to in your expression 1
Database Can't find the field '|' referred to in your expression 2
Works in WinXP, not in Vista 12
Button to insert boilerplate text into field in a parent form 9
forms() err - Can't find the form "frmDspEvents" 4
Refresh a combo box on a sub-form 2
Connect to sub-form without Parent/Child link 3
Database can't find the field "|" referred to in your expression. 8

Top