@andigirlsc
Thanks so much for your help i tried using the 2.8 objects rather than the 2.1 and i still get that error message.
It normally only happens if the record has a value from a pick list running off a query, but it does save the audit trail entry.
Thanks for the suggestion on the band...
First off i want to thank you for this solution!!
I have been racking my brains for days now!
I have got another issue where if i am using table/query in the form or subform it doesn't seem to like it.
When i hit save i get "Object doesn't support this property or method", do you have any...