Results 1 to 2 of 2

"Field cannot be updated" error, but then you can update it

  1. #1
    mcucino is offline Novice
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Providence, RI

    "Field cannot be updated" error, but then you can update it

    I have a combo box where the user selects a client from a list. The users like to type in the first letter and then select the client. I made some necessary changes to the underlying query for the combobox row source (whether the client has a balance due and whether the client is active - they need to be able to see all clients but also know their statuses). Since then, when they type in the first letter, an error pop up says "Field cannot be updated", but once you click okay, you can continue typing and it saves as usual. I just need to find a way to get rid of this pop up. It only happens on new records, so I thought about making a dummy record that says "Select client..." but I'd rather know what the actual problem is than just put a quick fix on it. Any thoughts?

  2. #2
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Any thoughts?
    yes, but none to help you since you have not provided any detail which might explain what is going one. what is the sql to your combo? is the combo bound and if so to what field? what is the recordsource to the form the combo is on? are there any events around the combo? if so what are they and what is the code?

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

Similar Threads

  1. Replies: 3
    Last Post: 06-06-2018, 07:26 PM
  2. "The field cannot be updated" error
    By jmuirman1 in forum Forms
    Replies: 3
    Last Post: 05-04-2018, 06:08 AM
  3. Error: "Cannot update. Databse or Object is read-only" Issue
    By excellenthelp in forum Programming
    Replies: 4
    Last Post: 07-30-2014, 10:28 AM
  4. Error # 3164 "field cannot be updated"
    By bbrazeau in forum Access
    Replies: 3
    Last Post: 08-29-2013, 12:18 PM
  5. Replies: 5
    Last Post: 06-26-2013, 01:29 PM

Posting Permissions

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