Unbound calculation fields Return without GoSub error (#Name?)

[Rramjet]

Hi -



I have a form on which I placed some unbound calculation fields. Basically these fields simply provide a sum total over a number of other fields (e.g. the Control Source for Tot_1 is "=[var_1]+[var_2]+[var_3]").

These seemed to be working just fine ...until I opened the database this morning and received the following error:

"The expression On Load you entered as the event property setting produced the following error: Return without GoSub."

Clicking OK the form opens just fine BUT...the unbound calculation fields now all have "#Name?" in them.

What the...?

(I mean ...it was fine ...now it's not ...as far as I can tell nothing changed overnight ...ghosts in the machine? ...what the?)

Anyone else come across this problem? How can it be fixed?

[Rramjet]

OMG - the answer was right out of left field...

There was some VBa code I had that was an On Load event property of the form. As far as I can tell there must have been a minor error in that code that was only exposed when the unbound calculation fields were instituted. DO NOT ask me how or why - but when I copied the On Click code (which was the same - or so I thought - as the On Load code) and pasted over the On Load code (the error told me "On Load" was a problem so...) ensuring each version of the code was now precisely the same... everything worked again! The unbound calculation fields are back to doing their job again! The weird thing was that yesterday it was all working fine - but today it was not. I am still utterly perplexed (still saying "what the..?"). I KNOW there must have been a variation between the On Click and On Load codes - but WHY it was only exposed whn unbound calculation fileds were placed on the form is absolutely beyoond me - but there it is. Go figure...