Speed total calculation of Form with subform (for invoicing)

[steveroot]

Please help, i've looked through access help and the archives here but havent found the answer, i think its one of those really simple in hindsight questions!

I have an invoicing database for our small office. The 'Invoice' form opens as data entry, the customer is selected from a list, a couple of header fields are completed (delivery date, how the customer found us etc) and then the individual items are entered into a subform.

The subform has a total field (which is invisible on the main form as the subform view type is datasheet) and the Main form picks this total up to display on the main form, then calculates taxes based on the total.

A simple scenario? It has been up till now, but we have noticed a significant slow down in how fast the total on the main form is calculated. Does anyone know how we can speed this up please?

PS - I don't *think* this is due to the size of the database, it is as slow on PC's on the network and just as slow as the machine that acts as our file server.

Thanks for any tips!
Steve Root

http://www.rootskitchens.co.uk

--
Steve Root

http://www.rootskitchens.co.uk

 

[JerryDennison]

Are you using any type of domain aggregate function? i.e. DLookUp()? These are notoriously slow. How are you arriving at the calculations?