Update via Form

[Nancy]

I have created a form to do a search and to do updates on
a table. It is working fine UNLESS I try to update
immediately AFTER I do a search. I get the following
error msg:
Run time error '3211'
The database engine couldn't lock table 'TempProv' because
it's already in use by another person or process

I've tried to change record source to another table before
the update (Me.RecordSource = "Provider")
and I've tried closing the table before the update
(DoCmd.Close acTable, "TempProv") ... Neither of these work

Any suggestions would be greatly appreciated. I posted
this question last Thursday, 11/13 ... but it seems to
have disappeard !