Results 1 to 3 of 3
  1. #1
    mr_right is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2013
    Posts
    11

    Value cannot be added

    Hi!
    I am newbie here and a beginner in access.
    I am building my sample database and i cannot put value on text box.
    This is the error i've encountered.
    "The value cannot be added to this new row until the row has been committed".


    Any help is highly appreciated.
    This is my sample database done in access 2007.

    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Cannot use one form to enter data into these two tables. Use two forms. Can be in a form/subform arrangement. Review http://office.microsoft.com/en-us/ac...010098674.aspx
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mr_right is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2013
    Posts
    11
    Thanks. It helps!

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

Similar Threads

  1. Need Criteria added SQL Statement
    By Ran in forum SQL Server
    Replies: 4
    Last Post: 07-31-2012, 10:07 AM
  2. Report won't show added field
    By Jojojo in forum Reports
    Replies: 0
    Last Post: 11-12-2011, 01:14 PM
  3. Extra space added
    By allenf in forum Forms
    Replies: 2
    Last Post: 07-25-2010, 06:57 AM
  4. # added to string with Dlookup
    By normever in forum Programming
    Replies: 1
    Last Post: 02-27-2009, 10:52 AM
  5. Added items in a column.
    By Wrangler in forum Forms
    Replies: 3
    Last Post: 03-25-2006, 07:56 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