Recent content by executiverocker

thanks!! it was making me go crazy! yeah it was almost there, ill have to keep this handy! Ill know for next time, thanks :D

ok thanks ill zip it up

http://public.box.net/executiverocker72993 you should be able to access it from there

the sub form is called "transactionpart subform" on the list, ive tried that formula and again ii get a #name? error the text box on the main form is called mainformtotal the text box on the subform is called total cost the box on the subform with the information i need is called linetotal

=Forms!Transaction.Form.transactionpart.Form.linetotal throws up a #name? error. the text box is called totalcost so no conflict

ok ive put it inside the form footer of the subform, but it doesnt appear. Is this because the subform is a datasheet?

well when i run the sum([linetotal]) it keeps giving me #error. the table shows linetotal as 0.00 for every line. So i thought it may be something to do with that? The line totals are correct when the form is run though

ive tried that, it works it out in the form, but if i goto the table, there are no values stored in the "line total" column

im building a database that will take customer orders, but whatever i do i take one step forward and 12 steps back!!!!!!!!!! ive got a transaction form with transaction ID, date and time, then a subform that contains Item ID, description, quantity, price and line total. Ive been trying...