Problems when closing forms

  • Thread starter Thread starter Uros
  • Start date Start date
U

Uros

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
 
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
 
Back
Top