Results 1 to 4 of 4
  1. #1
    FriQenstein is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    98

    Updating/Changing values/fields for an existing record

    Greetings all,

    Scenario:
    A user finishes repairing a unit and needs to update the Status in the database. They open a form that allows them to search for that item, by serial number.
    Now, they need to be able to change the Status and save the changes to the record.



    What would be the best, or preferred, method to do this?
    Would I use entry fields in the form to somehow amend the record's data? Or would they need to edit it directly in the table view?

    Thanks.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Most commonly the form would be bound to the table, so any changes made there would reflect in the table. Most of us never let users directly access tables or queries, only forms and reports.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    FriQenstein is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    98
    @pbaldy,

    Thanks for the reply.
    I'm assuming I would just use a normal form that links to the table as you mentioned? I ask because, I've only dealt with creating new records so far, not actually amending an existing record.
    I'm just not certain how to limit the edit to the existing record w/out creating a new record.

    Thanks.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Sounds like you have Data Entry set to Yes on the form? I would set it to No and use the data mode argument of OpenForm to either open it for data entry or edit. When editing, you can restrict to a specified record with this method:

    http://www.baldyweb.com/wherecondition.htm

    If you open the form to all records you can simply navigate to the one you want to edit, but I wouldn't recommend that if the table has a lot of records. It pulls all the records over the network which can hurt performance.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Updating an existing record
    By crowegreg in forum SQL Server
    Replies: 4
    Last Post: 07-26-2016, 09:23 AM
  2. Replies: 4
    Last Post: 02-05-2014, 04:35 PM
  3. Updating the Existing record with new data
    By rd.prasanna in forum Import/Export Data
    Replies: 4
    Last Post: 10-02-2013, 07:04 AM
  4. Replies: 1
    Last Post: 02-20-2013, 01:30 PM
  5. Replies: 0
    Last Post: 02-25-2011, 09:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums