What have I done?

[AN60]

I have a form with one sub form. For the last year I have had one field on the main form (actually on a page on that main form) and that field references one field on the sub form. This has worked ok until now and it no longer works. I have used =[my sub form name]![field name on sub form] . I haven't changed the name of the sub form or main form and definately not the field name. I've changed from A2000 to A2003. I've had this working every day up until now. My guess is that I've done something to kill things but just what I should be looking for is a mystery to me. Any ideas on where to start, assuming all form names have NOT been changed?

 

[mohammadagul]

in your design view go to subform border and right click to see the properties . see the relationship between them... you might have changed the relationship... that what i can figure out .....

 

[AN60]

Ok, after some testing I found that my db will reference the sub form fields if I open it (db) in A2000. If I open the file in A2003 the fields on the sub form can't be referenced!!! Can anyone help with this (works in 2000 but not in 2003)?

I tried adding a new unbound text box (in A2003) to reference the subform field and it is as follows; =Forms![my sub form name]![field name on sub form]. This still will not work in A2003 but I do get #name? showing in the new text box. I'm stumped, not that it's hard to stump me.

 

[AN60]

I've solved my problem and am posting the result for anyone who might need it in the future. It seems as if A2003, well at least my version, needs a more exact path when refering to a field on a sub form. I guess the old A2000 would "cut a bit more slack" in some areas but the new kid on the block wants things just right.
A2000 would accept;
=[sub form name]![field name on sub form]

A2003 will only accept;
=Forms![main form name]![sub form name].Form![field name on sub form]