Subform won't allow additions on MS Access 2010 but will in MS Access 2007

I have an MS Access application that was developed in 2003, then further enhanced in 2007 and now being run on 2010. One of my forms has a subform that in versions 2003 and 2007 will allow additions but when run in MS Access 2010 the subform won't allow additions. Does anyone know what may have changed to cause this odd behaviour and what I can do to fix?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Never had this problem with Access 2010. May be you can upload your forms and tables with sample data?
Jeffrey CoachmanMIS LiasonCommented:
<One of my forms has a subform that in versions 2003 and 2007 will allow additions but when run in MS Access 2010 the subform won't allow additions. >
Please be clear.
How are you adding New records?
    Via a button you inserted? (If so, what is the code)
    Via the built in New record button?
        If so, is the button active, or greyed out.
            If it is active, what happens when you click it?
Any errors?
Record added, but not saved...

Just saying "Subform won't allow additions", does not tell the whole story...

Rob4077Author Commented:
Hi Jeff. Sorry to be unclear. The sub form has the standard access record selectors and a add new record button button at the end of the list of records. When I run the app using 2007 the button is active and works. When I run it on 2010 the button is inactive. I am using the same backend and front end on both.

Based on comments coming back this shouldn't be happening so I will need to completely review my table structures and see if there's something that's creeping through on older versions but being captured by the latest version access.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jeffrey CoachmanMIS LiasonCommented:
Also is the button "always" greyed out, or only under certain circumstances?
What if you open the subform on its own?

Is this an issue for all users?
For all Computers?

Look for any code that sets "Allow Additions" to False

I am curious as well...

Keep us posted...


Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
I have seen others having similar issues with Access 2010.  To help reproduce the issue, do you have the 2010 SP1 update installed?
Rob4077Author Commented:
I am relieved to hear that others have had similar issues. Unfortunately this user migrated to MS Access 2010 without telling me and I actually don't have MS Access 2010 on my installation so I need to do all my testing remotely on their system. My remote test machine is using version 14.0.6112.5000 (32 Bit). Now that I look at the version information I note that on the test machine they've allocated to me it is an unlicenced version. Not sure if that means there are some limitations. I will have to check all the other machines having this problem to see if any of them have SP1 installed and to make sure they're running licensed versions.

At this stage I am going to assume that the issue is not a known issue with 2010 that is easily fixed and so it will need considerable additional investigation. I am going to a training course all next week and need to spend the next few days preparing for it so I won't have time to review and fix until week after next. I don't like leaving questions open for that amount of time so I think it best if I close out the question now and thank all of you for your support. I will post an update later when I find out the ultimate cause.

Thanks for your kind assistance.
Rob4077Author Commented:
Forgot to answer:
>>Is the button "always" greyed out, or only under certain circumstances?
Always greyed out

>>What if you open the subform on its own?
Button is still greyed out

>>Is this an issue for all users?
>>For all Computers?
Only tested on two machines and same problem exists for both

>>Look for any code that sets "Allow Additions" to False
Checked for that and Allow Additions is set to Yes
Rob4077Author Commented:
In case you're wondering, the record source is not a query but just a table

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
<Will post the resolution later when I discover it>
Then there was no need to close the question...
Rob4077Author Commented:
Jeff, only closed it out to avoid keeping a question open and unattended for 2 weeks.
Jeffrey CoachmanMIS LiasonCommented:
<Jeff, only closed it out to avoid keeping a question open and unattended for 2 weeks.>
This is not really a reason to accept posts that do not resolve the issue...
Only close a question if it has been resolved.
Nobody here was rushing you...

Otherwise just ask that the Q be deleted.
Rob4077Author Commented:
I have left questions open before and after a few days I get advised that I should close the question down or it will be closed for me. I try not to clutter the system unnecessarily.

The answers provided did lead to the solution I needed in the immediate term. I knew I had limited time to look into this but I wondered if there may have been an easy and immediate fix  (e.g. I recently discovered that I simply had to change a setting on another software package I use to make it backwards compatible after an upgrade) and I have no knowledge of the differences between 2010 and 2007 Access. There wasn't but there were a few anomalies for me to look into, i.e. SP1. I asked the user to upgrade immediately but he hasn't replied to me yet either.

 I apologise if my closing the question seemingly prematurely has annoyed you but I think its unfair to leave an open question in the system too long while the person asking finds time to work on the suggestions. I value the support I get from EE Experts too much to add to their annoyance by doing that.
Rob4077Author Commented:
Thanks to helping me work through this one. Will post the resolution later when I discover it
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.