Subforms Updating other Subforms Problem When Opening a Form

[llyal]

Subforms Updating other Subforms Problem When Opening a Form

I have a form with several subforms; some of the subforms have OnCurrent events that update other subforms on the main form; when i open the main form for the first time, i get a run-time error 2455 - you have entered an expression that has an invalid reference to the property Form/Report; i am guessing that some subforms are loaded before others, and those subforms that have OnCurrent events are trying to update the other subforms before they are loaded; how do i prevent this error?

Thank you!
Llyal

 

[ingvar68]

i think you wrote wrong code. you must write so:

forms("MAIN_FORM_NAME")![SUB_FORM_NAME].form.control("NAME")

& my other advice:
use ufter_update event if possible

glad to answer

 

[llyal]

The problem deals with subforms updating other subforms; Access has some difficulties; the solution uses text fields placed on the main form that the subforms use to pass information and update themselves; not very elegant but works;

Llyal