Where am I in the table when my UDF bombs??

[G Lykos]

Greetings! Have a UDF that is used in an append query, and it chokes on a
particular source data combination. Is there a simple and direct method to
determine the record number in the source table when this happens?

Thanks,
George

 

[Steve Schapel]

George,

You will need to give more details before anyone could give an
intelligent reply. But probably not, if you are talking about an Append
Query... as far as I know, this does not proceed by sequential
individual records.

 

[G Lykos]

Steve, I thought the description was reasonably unambiguous, but I'll
elaborate - an append query which includes a UDF call is reading records
from an input table, and on some data combination the UDF errs out. I want
to go to the problem record in the datasheet view of the table. The
datasheet view of the table has a record position indicator at the bottom.
When I stop on each UDF call, the query appears to process the input table
in the same order as displayed in the datasheet view. Can I somehow read
the current record number inside the UDF (short of filling a calculated
record number field and passing it as another parameter to the UDF)?

Thanks,
George