Cannot edit record on subform in Microsoft Access 2003

Posted on 2011-04-25
Last Modified: 2012-05-11
I have a table (Table_A) of imported information for our accounts in reference to the items they order.  The three fields I am concerned with in this table are Account#, Item#, and Order_Qty.  I have a 2nd table created locally in my DB (Table_B) with three fields, Account#, Item#, and Adjusted_Qty.

I created a Select query (Query_C), joining these two tables together by Account# and Item#.  The query returns the following four colums: Table_A.Item#, Table_A.Account#, Table_A.Order_Qty, Table_B.Adjusted_Qty.

I created a form (Form_D) with Record Source set to Query_C.  The main form has no fields displayed.  

I created a Subform (SubForm_D) with the same Record Source (Query_C).  I set up the Subform with a Default View of "Continuous Forms" and want all of the records returned from the query to show so that the end user can go right down the list and enter the Adjusted Quantities in sequence.

When I click in the first Adjusted_Qty field on the subform I get a cursor.  But, if I try to type a value into the field my PC just beeps at me.  I do not get any error messages.

All of the following options on the Data Tab for both Form and SubForm are marked with "Yes": Allow Filters, Allow Edits, Allow Deletions, Allow Additions, Data Entry.

Why won't it let me enter values into the Adjusted_Qty field for any of the items in the list?
Question by:jmcclosk
    LVL 119

    Accepted Solution

    see this link for possible reasons why the data are not updateable and for some possible solution

    Author Closing Comment

    After reviewing the information in your link I was able to determine that my query was not updatable with the relationships I had set up in my two tables.  I was able to consolidate them into one table and it is working now.  Thanks for the lead!

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now