Help, database closes on Docmd. double click

[GoinDeep]

Ive created a database that has been working very well for over two years. I have made several modifications over the years with no major problems. The database was originally created in ACCESS 2000.

On one of the many forms I have their is a listbox with an event triggered when double cliking on the list to Docmd.openquery"xxx" Lately when I try to double click on the list I simply get blown out of ACCESS with no error message or anything. This seams to be an intermittent problem with results varying from different pc's.

One thing worth mentioning, I am currently using ACCESS 2003 for evaluation.
Any suggestions?

 

[ducker]

what happens when you run that query by itself?
will it run correctly? It sounds as if it might be corrupted.

 

[GoinDeep]

Ducker,

Well I ran the querry in question without using the double click. The querry ran fine. And now everything is working, including the double click!

Not sure I understand why but am happy thing are back to normal.