Query running twice???

[dirkg]

Hi,


it appears that my queries always run twice. When I open a query where I use a custome made function in, you can see it loading since the data are apearing one after the other. But when all the list is shown, it disappears again and starts running again. I have placed some debug.print in the code of my function and there I can see that the function is indeed ran twice for every record. Dou you have any idea why this is and how I can prevent this since now my query takes twice the time to open...

Thanks a lot in advance


Greetz,

Dirk

 

[Orion45]

Without seeing your code my guess would be that you have a Requery statement somewhere on the form that is causing it to run once and then a second time. When queries do this on my forms a requery is usually to blame. hope this helps

 

[dirkg]

The problem also arises when I just open the query so a requery is not the problem... :s