Most if this is a discription for anyone trying to help that needs more then the actual question. Skip to the last paragraph for the actual problem.
I have a form, Frm Art Sheet, with a sub form in it, Frm Numbers Catagory, They are linked using a unique key from the table for the main form...