sumform calculation HELP!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am creating a book order database and have a subform with book_id,
quantity, cost and orderline cost. i can get the orderline cost to add the
multiple items per order using =sum([cost]) which works fine.

i would like to display the total (orderline cost) on the main form in the
field Total_ex_VAT but anything i try comes up with error. i have tried
=DSum("[Orderline cost]","ProductLine") which comes up blank as for some
reason the query is blank.

also the query uses the =sum([cost]) and sums the whole query when it should
just sum each order. any ideas would be great. thanks, Ad
 
By coincidence I've just answered this below. To access a subform's
properties or controls you need:
Forms![main form name]![subform name].Form.[control or property]
 
Back
Top