This could be several things.
Any chance you are setting Echo off in your code, and it is not being turned
on again? Macros turn it on again when they terminate, but code does not.
If you are working with crosstab queries that have no Column Headings
property set, Access has to run the query to completion before it knows what
the fields names will be. So if you are designing a report based on a
complex query, this can cause copious pauses. Setting the Column Headings or
temporarily assigning another fake query should work around that.
If you are actually experiencing crashes (rather than pauses), there are
several things you can do. For a list of suggestions, see:
Preventing corruption
at:
http://allenbrowne.com/ser-25.html
There are lots of items there. All of them are significant.
