Runtime Error '2465'

[Guest]

I've created a new access2003 database to try and solve this error im getting
on my main project.

I have 2 forms, frmMain and frmSubForm. Form SubForm is a subform on FrmMain
i have 1 text box on frmMain which is "text0" and 1 text box on Form
frmSubForm which is "sub1". Box text boxes are unbound.

ive opened frmMain and typed in test in text0 on frmMain and typed hello in
sub1 on frmSubForm.

using the intermediate window in Microsoft Visual Basic, i've typed the
following

?forms!frmMain.text0
which returns test

?forms!frmMain!form!frmSubForm.sub1
which returns a msgbox "Runtime Error 2465"

Can anyone help me get the results from my subform? I need to find the
correct path to the text box on the subform as my main project has a few
control sources =forms!.....

 

[Allen Browne]

You have the Form part in the wrong place, and you must use a dot (not a
bang) before the property.

Try:
? Forms!frmMain!frmSubForm.Form!sub1

Explanation:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

 

[Guest]

Many thanks Allen,

I've tried loads of different combinations. Its nice to have the right one.