>Hi guys,
>
>I have created a form set with 4 forms, and a 5th form that acts as a menu to the other 4. On the 5th form, I have an exit button to release the formset, but when I do, I get the following error:
>
>For i= 1 To m.nTablesUsed
>Error: 27
>Not a Numeric Expression
>Method: Destroy
>Line: 52
>
I see that you are incrementing to a variable [m.nTablesUsed]. If this variable was created in a form method, it will go out of scope when the method is completed. The only way to avoid that is to declare that variable Public.
You could run the debugger to watch for that variable and see when it is defined and when/if it ever gets released.
Mark McCasland
Midlothian, TX USA