here's one that's annoying me!

attached .mdb is a crude routefinder using DAO recordsets and SQL -- somebody was asking for something like this, and an earlier version with more complicated map and simpler table structure seemed to work fine.

this evening's version (simple map, but tables to allow an arbitrary number of disorders) goes mad!

the trouble seems to be that there is something asynchronous going on.

...if you try the mdb with slowdown OFF then the code goes mad and produces lots of duplicate results, but with slowdown ON everything works fine (as far as it goes, cos it aint finished yet)

the only action of the slowdown routine is to add a msgbox that slows things down:

Code:
    '   ############# THE SLOWDOWN ROUTINE ################
    If goSlow Then
        unhR.MoveLast
        MsgBox "There are " & unhR.RecordCount & " unhandled possible routes to investigate"
        unhR.MoveFirst
    End If
anyone got a neat trick to flush whatever A is caching ??

i tried some doevents here & there but it didn't help, i suppose i could loop thru a few thousand doevents but it doesn't seem very attractive.

you'll need a DAO 3.6 reference of course



izy