Basically, i have several yes/ no boxes and i want to make a running cost sort if thing. If one box is ticked then Total cost will be £2 for example, and if you tick the next box then the cost will be £5. But if you untick the box the price will be taken away again.
Any help GREATLY appreciated!
Edit Nearly solved guys! Just have to keep at it!!! What i did was for each tick box create a text box and the put this in each text box's control source: IIf([NAME OF TICKBOX]=True,10,0) This then put 10 in the box if true and if false 0 i then changed the format of all the text boxes so that it displayed currency, Thus giving a price! I then created another textbox that allowed me to calculate the total of all the other text boxes (=[Text38]+[Text40]..). the next problem is that i have to store the value calculated into a field, but how can i do that?! (btw i appreciate that there muct be an easier way but i couldnt find it, suggestions greatly welcomed!!)
Mikk
Any help GREATLY appreciated!
Edit Nearly solved guys! Just have to keep at it!!! What i did was for each tick box create a text box and the put this in each text box's control source: IIf([NAME OF TICKBOX]=True,10,0) This then put 10 in the box if true and if false 0 i then changed the format of all the text boxes so that it displayed currency, Thus giving a price! I then created another textbox that allowed me to calculate the total of all the other text boxes (=[Text38]+[Text40]..). the next problem is that i have to store the value calculated into a field, but how can i do that?! (btw i appreciate that there muct be an easier way but i couldnt find it, suggestions greatly welcomed!!)
Mikk
Last edited:
