Subform won't allow additions on 2010 but works fine on 2007

Posted on 2012-12-31
Medium Priority
Last Modified: 2013-01-25
I developed a database on MS Access 2007 and it's been working fine on many machines for many years. We have now copied the front end file to a new machine that is running MS Access 2010 and I am having a problem on one of the subforms. The subform will not allow new records to be added. The front end was just copied straight accross - no changes - from a 2007 machine to a 2010 machine. All the settings appear normal. Does anyone know what may have changed in 2010 to cause this strange behaviour?
Question by:Rob4077
  • 3
  • 2
LVL 77

Accepted Solution

peter57r earned 1336 total points
ID: 38732239
Can you confirm that other aspects of the app are working normally- you can add/modify/delete records in other forms, for example.

Do you get any errors if you Debug>Compile the app?

Author Comment

ID: 38732270
No errors when I compile and I haven't found any other peculiarities. It appears that this is the only form that is playing up.
LVL 77

Assisted Solution

peter57r earned 1336 total points
ID: 38732307
it would be ideal if you could post a file containing the problem form & associated tables/queries.

If you can't do that then at least create for yourself a new database and import just the form and any required tables/queries to see if the problem persists.

If it does then we need to know (at least the following)..
-the sql of the recordsource for the subform
-the link fields between the main form and the subform
-any code in the subform
-the exact nature of the problem- can you move to a new record? do you get any error messages, for example.
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 664 total points
ID: 38732551
1. Normally it is recommended that you create a new blank database in the newer version (2010) then import all the objects from the 2007 DB.

2. What happens if you just created a new subform from scratch?

Author Comment

ID: 38745827
Sorry about my delay getting back to this. I have been inundated with work plus had a sick day. I will see if I can do a few tests this weekend and respond.

Author Comment

ID: 38820780
I've had a change of jobs and so finding time to resolve this on a machine that has MS Office 2010 is proving impossible. I will need to close this question and raise it again when I have time to follow it through.

In fairness your answers haveanswered my question - there is nothing known that has changed in 2010 that would be causing this problm.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

624 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