subform data taken from variable

[me1258]

Hi
I have more questions on this ticketing program I am trying to get working.
I have buttons along the side of my form for increasing and decreasing the number in a text box which represents how many tickets the customer wants.
I need to take that number and display it along with the rate and total cost
in a sub form. How do I do that? DO I put that info into a table ( and if so how do I do that) and then display it via a query. I want the value to change each time the customer changes the ticket amount. Also there are several types of tickets so the first column would show ticket type... ie adult.... then second column would show ticket price. the third column amount bought the 4 column will show total cost. Each time the user changes the value in the txtbox the subform data much change also

I am using access 2003.
Thanks

 

[me1258]

Clarification

To Clarify since I have no reply s yet the subform or what ever I use to display the users choices must be able to be edited by the customer. They should be able to choose say Adult ticket in the subform area and change the amout of tickets there are.
Thanks