passing data from subform to main form

[Veli Izzet]

Hi all,

I have a form subform where the name of the subform is
frmUrunAlimDetaySubform.

On the form footer of the subform there is a text box with sum(Prices).
This textbox has a name Text59.

Why can I not get this data to the main form with the syntax
=frmUrunAlimDetaySubform!Text59


I must be doing something wrong, and I need help..

Thanks for answers..

 

[Roger Carlson]

To access a control on a subform, you need to do it like this:

=Forms!Mainform Name!Subform Controlname.Form!ControlName

Since you don't give the name of your main form, I'll call it MainForm.
Just substitute your mainform name in this line:

=Forms!MainForm!frmUrunAlimDetaySubform.Form!Text59

This also assume that the name of the SubForm Control on the main form is
the same as the subform name. This is not necessarily the case.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how reference a
number of things on subforms and subsubforms, including the above. It also
offers additional explanation.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Veli Izzet]

Thanks,

I will also check your website