>Bruce;
>
>Its not in the view, I just put two different 2-table views(totally different tables in the two views) on the same form running the same kind of checking code and get the same results. The requery just does not like to be the first command after a tableupdate.
By golly, I think you're right. I seem to have been able to reproduce your problem by sticking an insert & tableupdate right before a requery...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.