Random acts of Access!

[cjLiteStep]

After making great strides today, i had an old foe visit.
i have numerous fields on a main form and on a sub form that trigger a requery of the subform to reflect changes in a calculation
works great except every now and then, the controls on the main form don't trigger the update .. so i have to delete the code and re-enter it .. and things work for awhile.
and while i'm whining, sometimes when i'm working with forms and subforms, all of a sudden 1 subform will be on the main form 2 or 3 instances and the other ones are gone; again i have to delete and redo and cross my fingers

anybody know what's up?

cj

 

[rafe]

cj,

w/o particulars it's kind of hard to tell but it sounds like a "race condition." that is, you have two events where one depends on another but they're actually being done in parallel. in your case they're usually getting done in the correct order but every so often the dependent one gets done 1st.

i recently debugged one (Gord thank you). i added a

Me.Recalc

to the form & to make sure all of the needed calculations were done just before i used them & the problem went away.

the problem can also be caused by file writes not getting done in time, in that case you force a record write

hope this helps

 

[cjLiteStep]

rafe

good call
so far so good, and even better, if assume i did something i can fix that is causing these things(instead of random happenings) chances of fixing are sure better

thanks

cj