How do i refresh a recordset using the requery command without 
disconnecting the control on the form or how do i reconnect them after 
the requery and change the locktype
Thanks for helping