Results 1 to 6 of 6
  1. #1
    MLangendorf is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2016
    Posts
    50

    Subform will not allow me to enter data


    I have just created a subform to enter follow-up data but it will not allow me to enter data in form view.
    Any help would be greatly appreciated.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Can you enter and save data if you enter it directly into the query on which the form is based
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    MLangendorf is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2016
    Posts
    50
    Yes I can.
    I ran the query, and then entered data and then I checked the form that it was populating.
    Things seemed to work fine this way.
    I'm confused

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    On the Main Form, is the AllowEdits Property set to No...or is the Main Form perhaps Read-Only? The Access Gnomes consider adding Records to a Subform to be 'editing' the Subform Control, and you'll get this type of behavior.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    MLangendorf is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Jun 2016
    Posts
    50
    I decided to start from scratch and design the subform based on the table and not a query.

    I also had to set the parent and child links parameters.
    Seems to now work perfectly.

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

Similar Threads

  1. Replies: 7
    Last Post: 09-04-2013, 03:28 PM
  2. Replies: 3
    Last Post: 11-25-2012, 06:09 PM
  3. I can't enter data into a subform
    By MichealShinn in forum Forms
    Replies: 4
    Last Post: 06-19-2012, 11:18 AM
  4. Replies: 4
    Last Post: 05-28-2012, 09:39 AM
  5. Enter parameter value (subform combo)
    By AndycompanyZ in forum Queries
    Replies: 11
    Last Post: 06-22-2011, 08:33 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