Urgent! Accessing a text in a subform

[AT76]

Hi all,

I'm stuck trying to set a text field in a subform

Here's the scenario.

I have mainForm1. Inside frm_MainForm1 is frm_Form2.

I'm trying to access a text field in that subform to set the text value.

The code I have is the following:

Forms!frm_MainForm1!frm_Form2.Form!txtField = count

I appreciate any help provided!

 

[seaport]

If you are using Access 2003, the code may not work because Access 03 is more strict on code than Access 2000. Try the following code

Forms!frm_MainForm1.form!frm_Form2.Form!txtField = count

seaport

 

[PHV]

And what about this ?
Forms!MainForm1!Form2.Form!txtField = count

Anyway you may use the expression builder (loaded forms) to discover the correct syntax.

You may also have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886