Results 1 to 4 of 4
  1. #1
    cassidym is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    44

    Forms Locked in Edit Only

    Developed a simple database which has two forms based on queries that allow the user to add and edit data. But, for some reason, the forms only allow editing of existing data and will not let the user add new data.

    I've checked the property sheets to ensure I didn't inadvertantly lock the forms into the edit only mode.



    Any assistance would be appreciated.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    what are you trying in order to get to a new record? what have you tried? there are various properties that have different effects that can cause this, depending on the effort the user is using to get to a new rec.

  3. #3
    cassidym is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    44
    The forms are based on queries which are based on tables. I can go to the table and add data but can't add data when I open the form.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by cassidym View Post
    The forms are based on queries which are based on tables. I can go to the table and add data but can't add data when I open the form.
    take a look here: http://allenbrowne.com/ser-61.html

    There are many pages like that on the web. But that one pretty much explains everything I think.

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

Similar Threads

  1. Access Locked
    By anoobus in forum Database Design
    Replies: 3
    Last Post: 03-01-2012, 04:02 AM
  2. Locked for editing
    By Ted C in forum Security
    Replies: 19
    Last Post: 10-12-2010, 08:32 PM
  3. Replies: 0
    Last Post: 07-10-2010, 08:11 AM
  4. Locked out of my Access POS
    By oldhiway in forum Access
    Replies: 5
    Last Post: 05-23-2010, 10:04 PM
  5. Forms - Project Locked
    By Patrick.Grant01 in forum Forms
    Replies: 3
    Last Post: 05-19-2009, 07:03 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