Reply to thread

Message: [QUOTE="Access Developer, post: 7400187"] I suspect only testing will reveal "what is best", but, in many cases with Access the difference turns out to not have been worth all the testing necessary to determine it. I've long since stopped worrying about any VBA that is not in a huge loop... which would be very rare for anyone to have done in databases I've worked on (usually indicates a novice designed the approach being used). If you've worked with Access long enough to have a feel for "The Access Way", just follow your instincts and you're not likely to "wander far from the true path of enlightenment". <GRIN>: [/QUOTE]