Search:

Sorry but I will not log into your computer. I have also removed the id and password from your post as that could open you up to all sorts of problems. NEVER post that kind of info on a public forum...

Well I do not use the data environment nor do I use the VB report tools. I use Active Reports instead which works very well and makes it a bit hard for me to advise using those objects in VB. However...

So am I correct in assuming that you put that after the line that sets con to nothing? That would be a problem.

It would appear that your routine is not using Con nor RS so not sure why they are...