I should mention that these error messages happened after I unbounded the combo box. Before I even start on the command button.

Double check the properties for the Product subform.  The second error indicates to me the the linking fields are either missing or incorrect.
It's also possible that you have some errant code behind the scenes.  Do a Debug > Compile from the code window also.

The debug compile fixed the second error. I think I am going to have to do some work on the subform. I have some calculated fields that are relying on The SupplyCatergory Field. I think maybe trying to incorporate this field into the combo box might help. If you think that this is not the way to proceed let me know.

The command button works up until the error message appears.

I think I have it fixed except when adding a supply that is not on my list I have to assign a category to it. Which I don't mind much. But I don't know how to get around that. Any suggestions would be helpful.

Here are some Screenshots of my query that this runs on. I am having a bit of trouble with the functions. I need Category 5 to be 10% of the MfcPrice which is in the table. I also need to have Category 15 to be 100% of MfcPrice, Category 17 also at 100%, Category 21 at 100%, and finally every other category at 115%. I can get three to work but not 4. Maybe you could help me with this also. Is there a way to move them so that they are all on the bottom end of category numbers. Maybe I could use a <= function for 2 of them. Thanks