Updating Record

  • Thread starter Thread starter Joyce O
  • Start date Start date
J

Joyce O

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter using multiple options 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
log history of Access record changes,updated through a FrontPage A 2
Using email to update Table records 3
New Record 4
Access 2003 vs 2010 1
Access Updating inventory levels 0
Update query to set value based on position in recordset 2

Back
Top