Get value from subform

[chris5g]

Hi, Here is my problem:

I have a main form with sub forms. On the sub form I have a text field that equals =Sum(ProjectHours). I want to take that value and assign it to a text field on the main form.
This is the code that was working at home but at work it does not.

Private Sub Form_Current()
Me.AproxProjectHours = Me.TaskListTable_subform.Controls("text15")

End Sub

....my other programs are better

 

[smedvid]

Perhaps try
forms!form_name_here!Field_Name_Here.value = me.AproxProjectHours

me.refresh 'Need to refresh main form? not sure if you can call this or not...

'may need
forms!form_name_here.Refresh Recalc or Requery?

htwh,




Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[RoyVidar]

Try using the keyword Form in the reference

[tt]Me.AproxProjectHours = Me!TaskListTable_subform.Form.Controls("text15")[/tt]

See How to Refer to a Control on a Subform or Subreport for more info on referring to subform/subreports.

Roy-Vidar