form references not working

  • Thread starter Thread starter Sue D
  • Start date Start date
S

Sue D

I have some code that runs when a button is clicked (and
the code is part of the form). In it I open an Excel
spreadsheet and I use code to fill in the cells and
manipulate the data. It worked fine when I did it, but
when I gave it to 2 other people it worked for one and
not the other. I did not use the fully qualified name. In
my code I just referred to the field as AccountYear.value
and this shows a null for this one user. When I changed
it to Forms![frmMain]![AccountYear], it worked. Since the
code is on the form, shouldn't it be ok to not use the
full reference. Any ideas??
Please help. This is supposed to deploy on Monday.
Thanks,
Sue
 
Hum, I would use:

me!AccountYear

Perhaps some other code sets the data source of the form? If you do NOT have
a control on the form with the same name as the field name, then if you
CHANGE the data source of the form, then using a un-qualified field name
might give you trouble. So, I would qualify it with me!AccountYear.

I think also if I was to launch another application, I would also force a
disk write of the current form before I do this.

me.Refresh ' this forces data to disk...
 
Back
Top