We're having a problem with a datatype mismatch error when running a tableupdate on a view that updates 3 tables. The error box comes up with only "ok" and "cancel" buttons instead of the normal ignore, suspend, cancel, and ok buttons.

After the error, the data all seems to be getting updated properly. We've double, triple and quadruple checked all the variables that get sent to the view before the update, and everything seems to match against the view and the underlying tables, so at this point we're a bit baffled as to why this is happening.

Any ideas on how to troubleshoot and fix this issue would be greatly appreciated.

regards,

Jim Erwin