Using DAO 3.6:

When I Run the .OpenRecordset method I have a feeling that my App continues firing other events whilst my queries are executing:

I fire some code in a Validate event, which includes queries, by the time I get to the last query in the validate event Other code seems to have fired, completely rebuilt my treeview, and my Node is no longer the one I want and the app crashes!!! If I step through the code it works fine.

I want to run all the code in the validate event, even the queries, and not let VB do anything else till it's finished the one event. Is there a flag I can pass DAO to prevent it from letting VB Carry on...