Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2019
    Posts
    1,061

    Form/data locked

    Hello:



    I have previously designed forms (w/ sub-forms) w/o any issues.

    However, for this specific sample DB, I can neither modify data in the mainform nor in the sub-form. The main form's property is set to "Allow Additions". See attached screenshot.

    Does any know what's causing the issue and how to fix it? Upon opening main form, I want to be able to, e.g., change the following:
    1. Change any value in field [ORGANIZATION] or [MODULE]
    2. In sub-form's, [SOURCE_FIELD] or [RESEARCH_STATUS].

    Kindly request information as to what property needs to be changed to accomplish it.

    Thank you,
    EEH
    Attached Thumbnails Attached Thumbnails AllowAdditions.png  
    Attached Files Attached Files

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,992
    You are using aggregate queries for the record sources of both form & subform
    Aggregate queries are read only
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Join Date
    Feb 2019
    Posts
    1,061
    Ah, that makes sense.... thank you for this valuable information.

    That solved the issue.

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

Similar Threads

  1. Form Locked and don't know how!
    By ortizimo in forum Access
    Replies: 5
    Last Post: 03-29-2019, 05:24 PM
  2. Replies: 7
    Last Post: 12-09-2014, 03:06 PM
  3. How to solve locked error happening on data import?
    By accessmatt in forum Import/Export Data
    Replies: 5
    Last Post: 11-06-2014, 10:02 AM
  4. Form locked - won't allow new record
    By mhart in forum Forms
    Replies: 4
    Last Post: 02-22-2012, 02:46 AM
  5. form locked backend side
    By abner in forum Forms
    Replies: 5
    Last Post: 09-10-2011, 12:09 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