Problem closing form

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Uros

    #1

    Problem closing form

    When closing some forms in MSAccess 2003 Access is crashed (Microsoft Office
    Access has encounteres a problem and needs to close. We are sorry .......).
    If I close form without changes work OK, but when I change and save the form
    then access is crashed, but not always, in 10% working OK. I hawe ower 150
    forms but only a few forms make me trouble, one forms (Continuous Form) have
    link SQL tables as a recordset, one have RO passthrough query as recordset
    (also Continuous Form),.... I make new form (manualy) like problematicaly
    and old forms is deleted but problem rise again. I try decompile, compact,
    repair, I copy all object into new mdb file, but nothing helps.

    Anybody know the solution for this bug .... :-(

    Thanks


  • Uros

    #2
    Re: Problem closing form

    In my analyzing the problem I found that form work fine if I delete
    statement Me.Requery from Form event OnOpen. I don't know what happened on
    that ewent when I close form?

    In that form I initialize record source query (on Open event) and after that
    I must requery the form to see the result. Now I initialize query in a
    single function and in the last line with Docmd.Openform open form. Work
    fine, but I'm not satisfied becouse I don't know what happend on closing
    form and why that statement 'Me.Requery' crashed MSAccess.

    Uros


    Comment

    Working...