Slow to open form in design view

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a form in my database that has a good deal going on with it.
Its built on a simple query but has a few sub forms on it.

What I don't understand is why it takes so long to open the form in
design view? It never used to take this long. Its gotten slower over
time. It also takes a long time to save the form and often after
changes will get corrupted. When I'm in the form vba code and
compile, the screen flashes like a strobe for a few seconds before its
done. It doesn't do this on other forms.

Does any of this sound familiar to anyone? Any ideas what could be
wrong or is this normal?

Rob Buonocore
.

Relevant Pages

  • RE: List of options
    ... > Private Sub StoreLstBxSelBtn_Click ... > of the field to store the temporary data in. ... > adds your question and the answers to the database of answers. ... >>> the list box can be set to this query. ...
    (microsoft.public.access.forms)
  • Re: How can I Refresh the display of a open query
    ... See http://www.QBuilt.com for all your database needs. ... >>> I'm trying to have an open query automatically update after new records ... Query objects are static in that they ... >> Private Sub Form_Open ...
    (microsoft.public.access.queries)
  • Re: DIM and Set db once per module
    ... The only thing now is I can't get it to search the query without opening up ... If I click yes on the msgbox it opens the database and wors ... Private Sub Command1_Click ... Const qdfContacts = "Contacts" ...
    (microsoft.public.access.modulesdaovba)
  • Re: Why does this DMAX code fail
    ... Because the domain argument for a domain aggregate function needs to be the ... name of a table or query, ... > The database I have gotten has an event table with EVENT_ID as the PK. ... > Private Sub Form_BeforeUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Slow to open form in design view
    ... Its built on a simple query but has a few sub forms on it. ... Does any of this sound familiar to anyone? ...
    (microsoft.public.access.forms)