I fixed it the best I could, but you have a lot of significant problems.
1. Table naming convention is poor. Do not use spaces in any names (table or field or any other object)
2. Table names should be representative of the items that are contained.
3. Table design is wrong. Do not repeat data in multiple tables.
4. Do not store calculated fields in a table
5. Use queries to bring in related data
6. Give controls real names not "Text5" but "txtBxItemID" or "cmboItemName"
7. Do calculations in queries.