I can open with Access 2010. Don't know why can't open with 2007.
There is no
Private Sub TXT0_AfterUpdate() code in the posted db.
As already advised, c
ontrol used to enter/select search/filter criteria must be UNBOUND otherwise you change data in record. Use UNBOUND controls in form header for search. Review http://allenbrowne.com/ser-62.html
Why is ID field in GREY_OFFER not an autonumber? Why is there a 0 ID record? A field named ID is commonly accepted to indicate a field with unique values. This is not the case with GREY_SHADE table. This table's ID field is a foreign key for GREY_OFFER ID value. Give the fields better names, like: OfferID and OfferID_FK. Both of these textboxes should be set as LOCKED and TAB STOP No to prevent user edit or don't have these textboxes at all.
You have designed other tables without autonumber key field and instead of saving a key you are saving text into GREY_OFFER. This does simplify queries as there is no need to join tables but uses more storage for the data. That may not be an issue if your db does not grow to 2GB.
Might want to rename OFFER_ENTERY to OFFER_ENTRY.
Also, field named SELVAGE might should be SALVAGE. Two words with very different meanings.
Using all upper case is not advised as it is harder to read. Also advise not to use spaces in naming convention as you have in field names.
In future, please post code between CODE tags. Use the
# icon on post edit toolbar.