got past that error, but now it pauses on
' Requery the subform
Me.Contacts.Requery
Thanks for all your help keith, maybe if you give me your email address, I can send you the file, it might be easier, i must admit though it is a very messy database, this weekend I will be cleaning it up