"Overflow" Error message writing to audit log

L

Lesli

Hi,

I'm getting an "Overflow" message when trying to write to
an audit table using the following code.

Call
AuditEditBegin "tbl_CONSUMER", "tbl_audTempCONSUMER", "C_MM
IS", Nz(Me.C_MMIS, 0), bWasNewRecord)

and

Call
AuditEditEnd "tbl_CONSUMER", "tbl_audTempCONSUMER", "tbl_au
dCONSUMER", "C_MMIS", Nz(Me!C_MMIS, 0), bWasNewRecord)

This code is from Allen Browne and works fine on the other
three forms where I'm using it. The only diffence with
the table being audited here is that the primary key for
the table is NOT and autonumber field, it is a 12
character text field.

Any ideas?

Also, is there anywhere to go to find out what and error
message means? "Overflow" is not very helpful!

Thanks,
Lesli
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top