Subform referenceing problem between Access 2000 and Access 2003

[Sentry]

I am working on a massave aplication that has been running in Access 2000, but recently several of the file sharing users have installed Access 2003 because of the limited availability of Access 2000. All the users are using the same file off the server.

The problem we are having is that when we reference a subform in the "[Forms]![FormName]![SubformName]![FeildName]" Access 2003 does not recognize it and returns an error. I have found that if I will modify it to "[Forms]![FormName]![SubformName].[Form]![FeildName]" it is recognized in both 2000 and 2003.

To try and change every instance of a subform reference will take forever and I am garuteed to overlook something. We reference subforms all over our program, missing any one of them would be a disaster. Before I went to the tedious task of looking through everything I just wanted to throw the situation out there and see if any of you had any great ideas on how to get it fixed efficiently. I would apreciate any ideas.

 

[DanR]

Pat

I've just come to exactly the same problem while checking our Access 2000 software for upgrade to Access2003

That is, using [object]![object] to refer to controls on forms, subforms and reports.

You say that it is important not to take shortcuts, and to make the code "correct".

Now it's easy to be fooled (as I was) into thinking that if it works, then it's correct. Can you fill me in (or point me to) what is the correct way to handle references of this type?

thanks
Dan

 

[WayneRyan]

Dan,

Good reading - by Stewart

http://www.access-programmers.co.uk/forums/showthread.php?t=66115

Wayne

 

[DanR]

thanks

Thanks Wayne

This should be verry handy. I'm not sure, at a glance, how my code is non standard, but no doubt it will become clear.

Dan

 

[lgedeon]

I am having a similar issue (possibly the same?) whenever I open a form in 2003 it asks me to enter parameters. The parameters asked for are the references that I had entered. In my case, the references are in the query that populates the sub-form. Some of the references point to the parent form others to a different subform. All fail.

All of these references were working in 2000 and 2002(xp). I am using the [Forms]![FormName]![SubformName].[Form]![FieldName] format, so this may not be the exact same thing but sounds similar.