I'm attempting a conversion of a Access 97 app to Access 2010.
I'm hitting a problem with some of the forms where the Form_Load event is complex and sometimes references controls on the form.
2010 is now complaining that "You entered an expression that has no value", whereas 97 didn't.
Firstly is there an check I can add in before the offending lines?
I've tried the ones I can think of (isnull, isempty, isobject).
If there isn't, is the only solution to rearrange the code to a later event? and if so is there a site describing the new sequence of events, and what each was designed for?
I'm hitting a problem with some of the forms where the Form_Load event is complex and sometimes references controls on the form.
2010 is now complaining that "You entered an expression that has no value", whereas 97 didn't.
Firstly is there an check I can add in before the offending lines?
I've tried the ones I can think of (isnull, isempty, isobject).
If there isn't, is the only solution to rearrange the code to a later event? and if so is there a site describing the new sequence of events, and what each was designed for?