vb code help with form

[abz_y2k]

Hi

I have few problems with this datebase I created below (attachment) . When I enter the unit number it calculated the price correctly but I have to put the unit number for all the items before it carrys out a total cost and profit etc. also if I change one of the unit number later on it doesnt alter the total cost etc.

I know this can be done using VB, but am finding it hard to write the codes.

Can anyone please have a look to see how I can tweak it better


many thanks

 

[khawar]

In your case you have to update total cost after each unit update but this not not a normalised way to do it

 

[abz_y2k]

I have tried that, but it doesnt seem to work.

I was more thinking of doing it hopefully by loop or if statement but i just dont know how to

 

[khawar]

Upload your sample

 

[abz_y2k]

have you got an emial i can send it to you, cuz i dont have zip at work to upload this database

 

[khawar]

Is it not possible to upload it here

 

[abz_y2k]

i can only upload it if i can zip the file but am at work n dont have winzip program

 

[abz_y2k]

finally got it done

 

[khawar]

Check it Now

 

[abz_y2k]

Hi mate that works great but theres one problem i realised

you have to populate all the unit fields then it works out the total cost, recharge n profit.

what if i wanted to only like have two units fiels pupulated or one it doesnt work out the total

 

[khawar]

Ammended the sample

 

[abz_y2k]

Thanks alot mate.

much appreciated