Hi many thanks for your help.
before trying the marathorn editing all the forms/report/etc
i decided to try and import all the tables/queries etc into a empty database, to my amazement it worked and all i am now doing is re doing the corrupted reports.
once again many thanks.