2003-2010 Migration Problem #NAME

[adamtate94]

Hi Guys

I have developed quite a large database within Access 2003, with alot of VBA.
Having finally decided to move to Access 2010, I have opened the 2003 version on 2010, everything seems fine apart from some subforms having '#NAME' in the fields, but in the 2003 version they are fine.

Any Ideas?

Thanks in advance

 

[Minty]

What is the control source / field names where it happens? Maybe a new reserved word is being stumbled across?

 

[boerbende]

When you are in designmode, click 1 x on the subform and check the properties.
Is the name still the same as in 2003?

 

[CJ_London]

Also check that the form recordsource is being populated with valid sql or table/query name

 

[The_Doc_Man]

And, for that matter, verify that you have no broken references if it happens that the fields in question are filled by function from a query, since broken references make function names look like the names of non-extant objects.