Query Randomly Opens During Runtime

[Bonediggler1]

Hi-

I built an app that processes customer payment files. Part of the code runs 5 queries in sequence via "docmd.openquery" i.e.:

DoCmd.OpenQuery "Query1"
DoCmd.OpenQuery "Query2"
DoCmd.OpenQuery "Query3"
DoCmd.OpenQuery "Query4"
DoCmd.OpenQuery "Query5"

Everything works fine, except the 1st query in this sequence actually opens in a new window and stays open after the code stops running.

This query is not called from any other part of the project - I have no idea why this is happening.

Any insight?

Thank you!!

 

[AtlasAF]

What type of query is Query1

AtlasAF

 

[Bonediggler1]

Select query

 

[AtlasAF]

Can you post the rest of the code for review?

AtlasAF

 

[dhookom]

Why are you opening a select query?

Duane
Hook'D on Access
MS Access MVP

 

[Bonediggler1]

dhookum:

That's a great question. I really don't know. But I'm pretty sure I can go without it!


Thanks for being the sounding board I needed here...