>did that. We get a trigger failed even when the data is good. Not always though. All the form does is load the M.fieldname with values and then do an INSERT INTO tablename FROM MEMVAR

Are you sure all of those values are OK?

Really don't know what else could it be.