DSUM hangs form

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

Guest

I have a form with 3 sub-forms. One of the sub-forms populates some of the
fields using the DSUM function. Four out of five times the form hangs and the
fields don't get calculated.
The underlying query of the DSUM function seems to work flawlessly every
time. The database is using linked tables to Foxpro tables. Has anyone
experienced this problem or know of a solution.
 
I presume you are using the DSUM function in the ControlSource of the
control you are populating.

You can use DSUM as a function within the query itself. Try adding one of
the DSUM functions as a column of the query and see if it works. You may
need to play with the criteria element a bit.

Another possibility is to create one or more queries which perform the
summing for you. If you can include a key in those queries' output that you
can use to join it or them to the original query then you can create a final
query using them that will contain the sums as columns of the query.

Rod
 
Back
Top