Tim;
Thanks for the suggestion. Actually I did not have Error Handling on at the time.
I got a pop-up window with the error code and cryptic message. If it would drop
into debug at the offending line that would be great.
When these type of errors occur, are ther additional parameters avil I could pick
up to help determine the cause?
Thanks again for the suggestion.
Wayne
Quote:
> If you have the simple "On Error GoTo <error label>" error handling in the sub
> where the error occurs, you might try commenting out the On Error line, and
> when the error occurs, debug, and the offending line should be highlighted.
> This line will probably contain the reference to the non-existent field.
> Sortof a 'development time' inline error handler...wouldn't recommend leaving
> the usual error handling routines commented out....
> >Found the base problem. It appears this error occurs if you try to refer to
> >a field that does not exist in the table (I put an extra space in a field
> >name reference)
> >Does anyone know if there is a way to get the offending field name - it
> >would sure help in debugging?
> >> I am trying to adapt an old DAO program for a new use. The format of the
> >> table is changed. When testing, I get error 3265 (Item not in
> >> collection). I'm not sure what that means? I am trying to go through the
> >> table definition steps for any typos (likely with my typing) but would
> >> apprecuiate any pointers that might narrow the search.
> >> TIA
> >> -----------------
> >> Wayne Wengert