Can this be done: Input field to update field

[jash147]

Hi
I'm an inexperienced Access user who has to update a database regularly (to show which books have been sold). It would be much easier if I had a procedure where I entered a Number (the number of the record, generated automatically) and the record then was updated in the "Sold" field.
How do I start?
Pretty basic i know: I'm lazy i guess, and thought someone here could say this is where you look.
Too much red wine perhaps.

 

[jash147]

Hi
Now its morning and I'm feeling less than smiley:
My database has fields for author etc.
It autogenerates the Book Number which I record when a sale is made.
I'd like to be able to type out the number & update a field which records whether the book is sold or not, changing from "N" to "W" or "E".
Ideally therefore: an entry box for the number, then press return, then record updated.
Any suggestions?
James

 

[___]

Maybe we should have a smiley which indicates how drunk you are.

 

[jash147]

Yes: I deal in second hand books, so each record is unique and if I get a 2copies of the book I produce separate records, as each has to be described separately.
If I sell book 2030, then I want to update just that record.

 

[jash147]

Who is Annabelle?