Update Table - using Recordset

[CMontoro]

In a Library database, there is a form about Books Lends o returns (table: MovBooks) When someone needs a books, I need verify if the book is lended or not. (Table: Books, field: Status -Yes/No-) and update if its free
I want to resolve this problem using Recordset.
Thank you very much

 

[CMontoro]

Hi Pat
Sorry. I'm late
Yours answer helped me a lot
Thanks
Carlos