error msg

[akshal]

i just created a audit trail in my DB... however upon update and saving my changes... i get an error msg "13 - Type mismatch"... help pls... thankew in advance...

 

[MStef]

Hello akshal!

I suppose you are talking about RUN TIME ERROR.
I have had an experience with this error in VBA like this:
If Me.fieldX = 9 then...
but in fieldX was "" (empti). Check if you have got a similar VBA.
In fieldX must be any number.

 

[MStef]

It means that you try a mathematics operation on text field.