Updating Record

message from Joyce O on 19 May 2004
I have a database with over 20,000 records. Occasionally
I need to update a single record. My users do not have
access to the tables and only use forms. I want to create
a form to update a single record, but my Mastering Access
2000 tells me an update query is for updating numerous
records only. Can I use an update query to update just a
single record and use a form to do it with?

I appreciate your help, thank you
 
Lynn Trapp replied to Joyce O on 19 May 2004
Yes, you can update a single record using an update query, and you can call
that update query via a form. However, for a single record, simply using the
functionality of the bound form is likely just as easy.
 

Archived message: Updating Record (MS Access Error Message)