>In the above code, ProgressBarInit() is a method that initializes the Progress Bar. In this case, the Customer table's record count is passed to ProgressBarInit().
This will only work for a single table query (the original question involved a 3 table join), because any query that uses multiple tables might not access any one of the table's records on a one-to-one basis, and you would end up with a progress bar whose position means very little or nothing.
It is a good method, though, for single table operations. You can also use it in batch udpate and delete commands
REPLACE MyTable.MyField WITH "howdy" FOR oProgress.Update() && or whatever.
But this also gets back to a point I made earlier- your update code will be run once for every record in the source table, and this is going to cost you a serious hit in performance.
Erik Moore
Clientelligence