>>>This will work if the view is row buffered as long as you do a tableupdate on your current record. This may not feasible for what you are doing.
Dan><<<

Dan, unfortunately, it is not feasible.

This surely must be a Bug, in that a straight Copy give different results to s Sql Select... would you agree and how does one go about getting bugs fixed by Microsoft ?

Regards,

Gerard