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

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?
Rob4077Asked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
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?
0
 
Rob4077Author Commented:
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.
0
 
peter57rConnect With a Mentor Commented:
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.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
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?
0
 
Rob4077Author Commented:
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.
0
 
Rob4077Author Commented:
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.
0
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.

All Courses

From novice to tech pro — start learning today.