Lately I have been getting some strange errors on a form in my database
The error usually says something like:
"The expression OnLoad you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event or macro."
"There is a MS KB article Q279124 that states that you cannot have variables in your VBA code with the same name ascontrols on your Access forms. Also, it appears that your variable names also cannot conflict with recordset column names." My database doesn't have that problem.
This error comes only when I am using the access2000 database under access2002. It works fine when used on access2000. Tried converting to 2002 but doesn't help that way. I even copied the form elements to a blank form and copied all the corresponding event handlers using the Events tab in the Control Properties in Design View, but didn't help either.
I really appreciate if someone can tell me where the incompatability lies.
thanks
vish
The error usually says something like:
"The expression OnLoad you entered as the event property setting produced the following error: Member already exists in an object module from which this object module derives.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
*There may have been an error evaluating the function, event or macro."
"There is a MS KB article Q279124 that states that you cannot have variables in your VBA code with the same name ascontrols on your Access forms. Also, it appears that your variable names also cannot conflict with recordset column names." My database doesn't have that problem.
This error comes only when I am using the access2000 database under access2002. It works fine when used on access2000. Tried converting to 2002 but doesn't help that way. I even copied the form elements to a blank form and copied all the corresponding event handlers using the Events tab in the Control Properties in Design View, but didn't help either.
I really appreciate if someone can tell me where the incompatability lies.
thanks
vish