Period calculation on Access Query/Form not working correctly

[KevinSlater]

Hi,

I have an access database but a calcualtion is not working how it should. Theres a form named: "SCREEN-REP_CODE_SELECTION" displayed at first when you start the database from here you select a rep code from the drop down list, this takes you to another form named: "SCREEN-MAIN_ENTRY" (which uses the subform named: "SUBFORM-SCREEN_MAIN_DATA") from here click the button named: "Extra base info" which opens the form: "SCREEN-EXTRA_BASE"

On the "SCREEN-EXTRA_BASE" form this includes 3 fields named: New weekly base, start from period and pipefill.

If you enter some numbers into these fields, for example:
New weekly Base 10
Start from period 11
Pipefill 5

Then the PD11ACTFOR field on the "SUBFORM-SCREEN_MAIN_DATA" should calculate the values: PD11ACTFOR + PIPEFILL and should display 45, but these should only be added on period 11 (PD11ACTFOR), instead it does some calulations on all the other periods (ie on PD12ACTFOR, PD13ACTFOR, PD14ACTFOR ect).

(New weekly base of 1 = 4) so weekly base of 10*4=40

Sorry about the long explanantion, hope it makes sense?
Ive attached a cut down version of the database, i didnt originally design the database which hasnt helped resolve this, any advise would be great.

Kevin

 

[tmd_63]

Your main problem is that your form datafield for the PIPEFILL is labelled Text7 and Text7 is not used anywhere in your calculations.
Try looking throught the very long vba code behind SCREEN-EXTRA_BASE.BeforeUpdate .

 

[KevinSlater]

Ok thanks for the advice