Form won't let me edit text boxes

[jonman03]

Hey all,

I have a form (based on a query) that displays a variety of data in text boxes. I have the form properties set to allow edits, but I am not able to change data/numbers in the text boxes. The text boxes are not locked either.

The form uses parameter values passed from another form to filter the data.

What seems weird is that when I open the exact same database in Access 2007 it allows me to edit the form data like I wish, but when I open it in Access 2003 it does not seem to let me make any changes (???)

I need to have the ability for it to work in 2003 and 2007 as users of my database use both versions of Access.

Thank you for the help!

 

[boblarson]

What is the SQL for the underlying query?

See here for why a query could be read only.

 

[jonman03]

I don't see anything in my query that violates any of the things on that page...

The sql is:

SELECT AllSites_KPIs.Site, AllSites_KPIs.Region, AllSites_KPIs.Month, AllSites_KPIs.Year, AllSites_KPIs.[Local Currency], AllSites_KPIs.[Total Doses (Act)], AllSites_KPIs.[Total Doses (Bud)], AllSites_KPIs.[Total Doses (Fcst)], AllSites_KPIs.[Total Doses Comments], AllSites_KPIs.[Total Packaged Goods (Act)], AllSites_KPIs.[Total Packaged Goods (Bud)], AllSites_KPIs.[Total Packaged Goods (Fcst)], AllSites_KPIs.[Total Packaged Goods Comments], AllSites_KPIs.[Total Batches (Act)], AllSites_KPIs.[Total Batches (Bud)], AllSites_KPIs.[Total Batches (Fcst)], AllSites_KPIs.[Total Batches Comments], AllSites_KPIs.[Total 3rd Party Doses (Act)], AllSites_KPIs.[Total 3rd Party Doses (Bud)], AllSites_KPIs.[Total 3rd Party Doses (Fcst)], AllSites_KPIs.[Total 3rd Party Doses Comments], AllSites_KPIs.[Process Loss Yield % (Act)], AllSites_KPIs.[Process Loss Yield % (Bud)], AllSites_KPIs.[Process Loss Yield % (Fcst)], AllSites_KPIs.[Process Loss Yield % Comments], AllSites_KPIs.[Process Loss Yield $ (Act)], AllSites_KPIs.[Process Loss Yield $ (Bud)], AllSites_KPIs.[Process Loss Yield $ (Fcst)], AllSites_KPIs.[Process Loss Yield $ Comments], AllSites_KPIs.[Scrap $ (Act)], AllSites_KPIs.[Scrap $ (Bud)], AllSites_KPIs.[Scrap $ Comments], AllSites_KPIs.[Donations $ (Act)], AllSites_KPIs.[Donations $ (Bud)], AllSites_KPIs.[Donations $ Comments], AllSites_KPIs.[Total Direct Manufacturing Headcount (Act)], AllSites_KPIs.[Total Direct Manufacturing Headcount (Bud)], AllSites_KPIs.[Total Support Manufacturing Headcount (Act)], AllSites_KPIs.[Total Support Manufacturing Headcount (Bud)], AllSites_KPIs.[Total Manufacturing Headcount Comments], AllSites_KPIs.[Total Open Direct Manuf Headcount (Act)], AllSites_KPIs.[Total Open Direct Manuf Headcount (Bud)], AllSites_KPIs.[Total Open Support Manuf Headcount (Act)], AllSites_KPIs.[Total Open Support Manuf Headcount (Bud)], AllSites_KPIs.[Total Open Manuf Headcount Comments], AllSites_KPIs.[Total Direct Quality Headcount (Act)], AllSites_KPIs.[Total Direct Quality Headcount (Bud)], AllSites_KPIs.[Total Support Quality Headcount (Act)], AllSites_KPIs.[Total Support Quality Headcount (Bud)], AllSites_KPIs.[Total Quality Headcount Comments], AllSites_KPIs.[Total Open Direct Quality Headcount (Act)], AllSites_KPIs.[Total Open Direct Quality Headcount (Bud)], AllSites_KPIs.[Total Open Support Quality Headcount (Act)], AllSites_KPIs.[Total Open Support Quality Headcount (Bud)], AllSites_KPIs.[Total Open Quality Headcount Comments], AllSites_KPIs.[Total Manufacturing Spending $ (Act)], AllSites_KPIs.[Total Manufacturing Spending $ (Bud)], AllSites_KPIs.[Total Manufacturing Spending $ (Fcst)], AllSites_KPIs.[Total Manufacturing Spending $ Comments], AllSites_KPIs.[Total Quality Spending $ (Act)], AllSites_KPIs.[Total Quality Spending $ (Bud)], AllSites_KPIs.[Total Quality Spending $ (Fcst)], AllSites_KPIs.[Total Quality Spending $ Comments], AllSites_KPIs.[COGS Capex Excluding Quality (Act)], AllSites_KPIs.[COGS Capex Excluding Quality (Bud)], AllSites_KPIs.[COGS Capex Excluding Quality (Fcst)], AllSites_KPIs.[COGS Capex Excluding Quality Comments], AllSites_KPIs.[COGS Capex = Quality (Act)], AllSites_KPIs.[COGS Capex = Quality (Bud)], AllSites_KPIs.[COGS Capex = Quality (Fcst)], AllSites_KPIs.[COGS Capex = Quality Comments], AllSites_KPIs.[Cycle Time Avg (Act)], AllSites_KPIs.[Cycle Time Avg (Bud)], AllSites_KPIs.[Cycle Time Avg Comments], AllSites_KPIs.[WIP Net Inventory $ (Act)], AllSites_KPIs.[WIP Net Inventory $ (Bud)], AllSites_KPIs.[WIP Net Inventory $ (Fcst)], AllSites_KPIs.[WIP Net Inventory $ Comments]
FROM AllSites_KPIs, YearlyBudFcst
WHERE (((AllSites_KPIs.Site)=[forms]![CMD_EditEntry].[site]) AND ((AllSites_KPIs.Month)=[forms]![CMD_EditEntry].[month]) AND ((AllSites_KPIs.Year)=[forms]![CMD_EditEntry].[year]));

Basically just selects a ton of fields, then has some values passed from another form (CMD_EditEntry).

 

[jonman03]

Ha I just figured it out... something interesting to note:

I had an extra table selected (see the FROM "YearlyBudFcst" in the SQL) and didn't have any fields being pulled from that table. Once I removed that table from the FROM it allowed me to edit the values on the form.

 

[boblarson]

Ha I just figured it out... something interesting to note:

I had an extra table selected (see the FROM "YearlyBudFcst" in the SQL) and didn't have any fields being pulled from that table. Once I removed that table from the FROM it allowed me to edit the values on the form.

Yep, that would do it.