Subscript out of range Error Message
Posted on 2011-03-18
I have a function that which used to include this line:
varParts_GBL_identifier = Split(Forms!fdlgMain.tvw1.SelectedItem, " | ")
To enable the function to execute its code on more than one control I changed it so that it would accept a parameter.
The function is now called like this:
and the previous line has been replaced with this:
varParts_GBL_identifier = Split(strControl, " | ")
(strControl is the string parameter)
Unfortunately this now produces this error message:
Error 9: Subscript Out Of Range
Any suggestions as to why its giving this error message?