Results 1 to 2 of 2
  1. #1
    degras is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    72

    Allowing edits in a query based datasheet


    I have a datasheet that looks up data based on a query of two tables. The datasheet shows the data correctly, but it will not allow edits. I tried setting the data entry property to True but this had no effect. Also I was looking for the place where you can set the primary key for the form, but I could not find it. It would be good if edits were allowed on this form, is this possible?

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    You may want to check out this explanation of what causes a recordset not to be updateable.

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

Similar Threads

  1. Disallow edits to saved query
    By MWMike in forum Forms
    Replies: 2
    Last Post: 03-08-2011, 09:24 PM
  2. Form not allowing new entry
    By Lshy01 in forum Forms
    Replies: 1
    Last Post: 02-04-2011, 10:19 AM
  3. Autopopulate NOT allowing overwrite
    By ChrisCione in forum Forms
    Replies: 8
    Last Post: 09-03-2010, 06:29 PM
  4. MSA 2007 ... allowing VBA
    By asearle in forum Access
    Replies: 1
    Last Post: 08-16-2010, 05:07 AM
  5. Replies: 13
    Last Post: 11-25-2009, 03:10 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