Other causes of this error are:
- a problem wizard;
- a problem reference;
- code that is being interpreted wrongly;
- a corruption.
Regarding the wizard problem, see:
http://support.microsoft.com/default...b;en-us;306326
If the problem occurs under a predictable set of circumstances, you could
see if you can get it to occur using a known good database, such as the
Northwind sample database. If you can, the problem is with the wizards or
the registered libraries, not with your code and is not a corruption.
If that does not help, try this sequence:
1. Uncheck the Name AutoCorrect boxes under:
Tools | Options | General
Explanation of why:
http://allenbrowne.com/bug-03.html
2. Compact the database:
Tools | Database Utilities | Compact
3. Press Ctrl+G to open the Immediate window.
Check your references are okay (none marked "MISSING"), and uncheck any
libraries you do not need. If you are not sure what you need, see:
http://allenbrowne.com/ser-38.html
4. Make sure you have "Option Explicit" at the top of all your modules,
including any modules behind forms and reports. This helps prevent
misinterpreted variables.
5. Make sure the code compiles. Still in the code window: Debug | Compile.
Fix any issues, and repeat until no errors.
If that is still unproductive, try getting Access to recreate your database
for you, by following the steps for the first symptom in this article:
http://allenbrowne.com/ser-47.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"jv" <ju***********@hotmail.com> wrote in message
news:11********************@l41g2000cwc.googlegrou ps.com...
I have a form that is used every day to create quotes. However, every 2
weeks or so a user would randomly get an error 9 - subscript out range
message. I'm not using any array in this form. Does anyone know that
else might possibly trigger this error besides array?
Thanks
Julie