Form Calculation issue (1 Viewer)

[munkeyroot]

Hi Everyone

i have an odd think happening to my db

ok..so.. on my [frm_main] i have a total amount which is based on adding three different amounts together . not an issue all ok with that.

however i have created a new table and form for a rentals [frm_rental].
FK_ID relationship to [frm_main].[main_id].
this is sat on my [frm_main] in a Tab page.

on the [frm_rental] i have a text box (cost of install) that i have set to collect the total from the frm_main.

=([Forms]![frm_Main]![txt_OverallTotal])

two things are happening
1) on a (new) the amount is way out it just seems to pick up a random figure from some where, until i type an amount in another field on the [frm_rental], then it updated and grabs the amount.

2) once i update the rental amounts, close the app then load it backup again the amount reverts back to a random figure untill i update the rental form again.

really weird!! i've tried assorts from refreshing macros etc.

any thoughts guys?

cheers

munk

 

[isladogs]

Force the update by adding

 me.controlname.requery

using the name of your control

 

[arnelgp]

why not instead the subform get the value from the main form, the mainform feed the value to the subform through its current event.