Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sum in subform, can't get it into a form(textbox)

Status
Not open for further replies.

pinstripe

Programmer
Dec 27, 2004
52
0
0
hi to all,

this problem drives me crazy.

i have in a subform(Datasheet) footer, textbox "Totale"
and in it's controlsource:
=Sum([Stop Km]-[Start Km])

then on a form i have new textbox "Text81"(unbound)
and also combobox which has in it's After_update Event:

If (Me![IzpisPrevoza_Registerska_sub].Visible = True) Then

Me!Text76 = [IzpisPrevoza_Registerska_sub].Form![Text106]
-- this one is working fine
Me!Text81 = [IzpisPrevoza_Registerska_sub].Form![Totale]
-- this one doesn't work
there is no error but my textbox "Text81" remains blank

i did debug it:
first part - "Me!Text81 = " =Null
second part - "[IzpisPrevoza_Registerska_sub].Form![Totale]"
has the corect number(Sum)

any help is need it
thank's

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top