Cannot edit record on subform in Microsoft Access 2003
Posted on 2011-04-25
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?