A
Andy
I'm building a VBA form to retrieve data from an Excel
data source and there seem to be a few controls on the
form that continuously cause illegal operations.
I have traced the error to a few certain controls only,
and it seems to occur when you try to reference them by
name only (ie: typing ?txtControlName in the immediate
pane causes a crash). this is not the case for other
controls on the form and the problem is not limited to
text boxes as some of my combos are affected too. This is
a major pain as I have a number of procedures that are
receiving control names as arguments in Parameter arrays,
so has anyone any idea what is going on here?
Thanks
Andy
data source and there seem to be a few controls on the
form that continuously cause illegal operations.
I have traced the error to a few certain controls only,
and it seems to occur when you try to reference them by
name only (ie: typing ?txtControlName in the immediate
pane causes a crash). this is not the case for other
controls on the form and the problem is not limited to
text boxes as some of my combos are affected too. This is
a major pain as I have a number of procedures that are
receiving control names as arguments in Parameter arrays,
so has anyone any idea what is going on here?
Thanks
Andy