Cinema Booking System. (1 Viewer)

[xenovia]

Hi guys, I'm about to start developing a cinema booking system.

Basically what I'd like is a form with lots of combo boxes lined up representing seats.

When I click on one of the combo boxes, I want it to add a certain amount to the total cost (possibly in a sub form?), and then make the combo box unavailable to be clicked again (i.e. the seat is booked).

Just wondered if this was possible, and if any one had any advice on how to do it.

Thanks~!

 

[John Big Booty]

It is possible. Have a play with the attached sample DB.

 

[xenovia]

Looks good. Is it possible to do the same with check boxes? So if a seat is checked, then it adds $10 to the total and makes it unavailable for booking

 

[John Big Booty]

Yes it is. In the text field that is collecting the total put something like;

=Abs(Check0.Value+Check2.Value)*10

The checked value of a check box is -1 and the unchecked value 0 so you need the Abs function to return a positive result, then just multiply it by the sales value of you seat.