Linking update queries to check boxes

[Sephzer]

Help! I'm designing a database for my A level project at college and I just can't get this one section to work. I've spent alot of time linking things up so that you can't double book one of 4 rooms. It's a booking system for a recording studio. The thing is I have 3 basic packages of equipment and you can only choose one for each booking. The price is diplayed at the bottom of each package. I want to be able to check a box and then I want this price to be added to total price. I cannot link update queries to a check box I've tried every songle way I know. I'm not too familiar with access either :S. One more thing, I want to be able to tick a box which says Discount and then I want this to update the total price field again so it is multiplied by 0.9. I have manage to figure this out in an update query and it is also based on the fact that a band has made a deposit that is bigger than £0.00. I just cannot link it to the form.

If anyone can help it'd be much appreciated, I'm panicking too much over this project.

 

[GolferGuy]

What I don't understand is how do you want to use this check box and calculation within a form.

 

[chris davies]

I suppose you could have a yes/no field, as a boolean and use it as a flag. That is to say, test if it is either yes or no and perform the desired operation upon running a query against the value.

create a Form based on a query (which in turn is based on the table with the yes/no field), On one of the actions for the form run an if statement to see if the flag is set.


if(fieldName.value = Yes) then
update someotherfield
or perform a calculation
end if

This may be a bit obtuse for your needs but it should at least work. After trying this, you may see a better way of doing it. Thing is is getting it to work first.