Obnoxious Access VBA variable declaration problem
Posted on 2011-04-26
I am passing a variable between subs with an Optional switch set such that
example(data as string, optional err_code as single) is what is expected.
The receiving sub runs a series of proceedures depending on whether the err_code variable is populated. The problem I am having is referring to the err_code variable when it is empty. No iteration of null works and "" empty set also bombs out. I don't want to have to go back and populate all references to this sub with a 0, just so access will have a number to refer to when the field is supposed to be empty, so how do I achieve this? Thanks.