Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
February 18th, 2013, 12:55 AM
how to auto calculate in forms help
i have a tblTicket with a set of data about the amount of sold tickets with 2 seat options
2 data field
Combobox Stand, Cabin
in Tickets Form,
when i select ticket type Stand.
how do i make it auto calculate in the form to show the amount of sold tickets for 'Stand'.
and if i add new records it should calculate and add in the total amount in it.
any example for this kind of code??
sorry for my english
February 18th, 2013, 06:43 AM
I'm going to assume you want the total number of stand tickets sold to date for a particular event or for a particular date. One method is to create an aggregate query to sum up all of the number of tickets sold. Add a subform to your main form using the query as the record source. (You can format it so that it doesn't even appear to be a subform.) Then in the after update event on your combo box or sold_tickets box just use the code: me.subformname.requery
By qq2 in forum ASP Development
Last Post: December 16th, 2007, 08:20 PM
By ciggwin in forum Microsoft Access Help
Last Post: March 22nd, 2007, 12:24 AM
By Ghena in forum ASP Development
Last Post: April 20th, 2005, 01:39 PM
By mnghhl in forum ASP Development
Last Post: March 7th, 2005, 01:54 AM
By bradlam in forum Microsoft Access Help
Last Post: March 3rd, 2005, 11:47 AM