I have a one-record table (ControlFile) which I use to save totals and
other data to allow users to resume work after an interruption. Three
forms access this table. All three forms refer to this field in code.
All three find contain a text control bound to the field. I added a
new field to the table (AdditionalTitle). In all tree forms the code
stopped with the message 'Undefined variable.' After checking and
rechecking my spelling and struggling with the problem for a while, it
occurred to me to copy ControlFile and paste as ControlFileTest. I
changed the record source of one form to the new name and the problem
disappeared. I then renamed the original table as ControlFileOld,
renamed ControlFileTest to ControlFile, restored the record source for
the form to ControlFile and now all the forms work perfectly. Although
I found a solution, I'd like to know why the problem occurred in the
first place.
Cordially,
Robert