Question I developed an application in Access 97 that is working fine in 2002. In 2003 I can't reference subform text boxes in SQL querries, reports and such. I reference the subform text boxes as
forms![main form].form![sub form]![control]
I read the reference is now
form![main form]![subform].form![control]
Do you know which Access version the syntax changed to the latter and is there a way to make the old subform reference work. If not I have hundreds of lines of code to change.
Thanks,
Steven
Answer In Access 2003, the reference should look like this:
Forms![Main Form]![Subform].Form.Control
There are problems with working with older multiple versions of Access, and I'm afraid that will continue.
There are so many permutations to how this could have changed, it's tough to say how to fix it. If you have an old 97 version of the database, I would try different ways of converting it if you could. (I don't know how you did it this time.) If you have Access 2000, convert it to that first, and try running the Access 2000 version with 2003 (it won't need to convert it.) Try actually converting the Access 97 to Access 2003. Try importing all the objects from a converted version to a new Access 2003 file, run the debugger, compact and repair.
There is probably a combination that will work to translate it and get it to run.
Sorry I couldn't be more help, feel free to follow up if you think I might be able to help further.
