What does "subscript out of range" message mean when trying to cr.

[scottishfirefighter]

Im trying to create a new form or report using the wizard, and when i add a
particular field from one of my tables, i get a message saying "Subscript out
of range". What does it mean and how do i fix it?

 

[Allen Browne]

"Subscript out of range" means that the code is trying to refer to something
(typically a field) that it can't find.

If you get this message when running a wizard, Microsoft suggests taking
these actions:
http://support.microsoft.com/kb/303769
http://support.microsoft.com/kb/242218

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...

 

[David W. Fenton]

"Subscript out of range" means that the code is trying to refer to
something (typically a field) that it can't find.

More specifically:

It means that the requested item counter used for navigating a
collection is invalid for a collection or array is greater or
smaller than would be valid.