Cannot edit record on subform in Microsoft Access 2003

Posted on 2011-04-25
Medium Priority
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 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 35460367
see this link for possible reasons why the data are not updateable and for some possible solution


Author Closing Comment

ID: 35477074
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

621 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