Access Problem

See below the SQL statement that works perfect and allows me to add records to the form. However, since I did a compact and repair which came up with errors, when I openthis form (which is a subform for a larger from) and try to input reocrds I cannot! I am no longer able to add records. The company MSysCompatError table does not list the records which were affected other than tell me the table which the errors occured in (Which is where these files come from). I've been throught the table but can;t see anything which would casue it to happen. What I am looking for is suggestions on how to fix the problem. I cant send the database as it's too big. IF you think you can help. give me your ideas. The SQL BELOW WORKS PERFECT! SO NO CHANGES ARE NEEDED HERE, WHAT I NEED TO KNOW IS WHAT WOULD BE CAUSING IT NOT TO ALLOW ADDING RECORDS? Here is the SQL SELECT tbl_Transmittal_Details.*, [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] FROM tbl_boxes INNER JOIN tbl_Transmittal_Details ON ([login to view URL] = [login to view URL]) AND ([login to view URL] = [login to view URL]) WHERE (((tbl_Transmittal_Details.Transmittal_ID)=[Forms]![frm_Transmittal_detail]![Transmittal_ID])); ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Sunday Apr 1, 2007 2:35:47 PM: The query and has always worked, still does work on an earlier backup. The problem with the tbl_boxes I am sure, the compact repair has possibly deleted records and that is causing the query not to allow updating. As I mentioned the DB is too large to post. What I am possibily looking for is maybe a query to that can check the the tables makre sure records exsist where they should, It could be a 1 to many issue? ## Platform Access