Results 1 to 4 of 4
  1. #1
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286

    Cant EDIT Bound TEXTBOXES


    hello, i have a form that is based off a query. the "edit" function for the form is set to yes, however when the form loads, the bottom left hand of the screen says "data is uneditable". when i put the curso in the textboxes that are bounded, it says i cannot edit the textboxes on the bottom right hand. any ideas? thanks!

    the exact error message is "this recordset is not updateable"

  2. #2
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    and yes, i have primary keys in my main table. i have a concatenated key

  3. #3
    taimysho0 is offline Competent Performer
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    286
    one of the tables my query is connected to IS a linked table, i figure this is the problem but is there still a way around this? i want to keep that table linked because it provides current data

  4. #4
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    It really depends on what the relationship between the two tables is as to if you can update a query based on them together. See this for reasons why a query may be non-updatable:
    http://allenbrowne.com/ser-61.html

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

Similar Threads

  1. Bound form with bound combobox
    By Jerry8989 in forum Access
    Replies: 2
    Last Post: 12-05-2011, 01:50 PM
  2. Formating Textboxes
    By desibabu90 in forum Forms
    Replies: 6
    Last Post: 08-02-2011, 07:48 AM
  3. Combo Box Populates Textboxes
    By alyon in forum Access
    Replies: 11
    Last Post: 07-19-2011, 11:55 AM
  4. #Name? errors with textboxes
    By jasonbarnes in forum Forms
    Replies: 3
    Last Post: 12-16-2010, 09:51 AM
  5. Replies: 1
    Last Post: 08-05-2010, 12:11 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
  •  
Other Forums: Microsoft Office Forums