Results 1 to 5 of 5
  1. #1
    Jaik is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Aug 2016
    Posts
    33

    I can't edit text box on form


    I have two empty text box on form, but I can't put value inside of the text box.
    whenever I tried to put value in it, it says "This recordset is not updateable"

    So I updated text box properties, Enabled: Yes, and Locked: No
    Also setup the form property as Record Locks: No and Allow Addition/Deletion: Yes

    Is there any way to solve this problem?

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    The recordset on the form is the problem, you have a query there that does not allow updating and the textbox is bound to a field in that query.

  3. #3
    Jaik is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Aug 2016
    Posts
    33
    If that is the case, is there any alternative way to make memo text box in the from?

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Define the issue - you would like to update a field on a table, correct? Or many fields? Either make a form or subform with a recordset that is updateable, i.e. the table, or else have some behind the scenes vba code that does the updating instead of the form. You could put a subform in the same place as the fields are now so that it will look and behave much the same as it is now. Select the record that you are trying to update on the main part of the form and link to the subform so that it shows just those fields.

  5. #5
    Jaik is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Aug 2016
    Posts
    33
    You were right, I had to make a subform without any join, sum, and group by clause on query, it worked.

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

Similar Threads

  1. edit text box with new format
    By vicsaccess in forum Forms
    Replies: 4
    Last Post: 01-07-2016, 03:47 PM
  2. Edit a publisher text box with VBA?
    By wackywoo105 in forum Programming
    Replies: 4
    Last Post: 06-26-2014, 02:18 PM
  3. Replies: 1
    Last Post: 05-31-2013, 08:53 AM
  4. Replies: 14
    Last Post: 12-26-2011, 07:32 PM
  5. Edit Buttons for a Rich Text Box on Form
    By trb5016 in forum Forms
    Replies: 2
    Last Post: 10-13-2010, 12:28 PM

Tags for this Thread

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