hello,  I an working on lessons 26 to 28.  I used the same principal to create a Jobsite form - we work on cell towers.  each project has  list of potential things that we could be asked to do.  I set up this form that works great... i can add whatever has been requested and it gives me the total of the workorder.  The trouble came when i used the same principal for my SubLabor form.  the subs typically make a percentage of the total workorder and they may do all of the labor or only part of the labor.  I was able to set up the form so i could choose the subcontractor... and it tells me the percentage that they get and i can enter in another field what percentage of the job they did.  Then using the Total from the Jobsite form i can calculate how much the sub is owed.  However... I am not able to total up that calculated field in the footer (maybe an inhouse crew did half the work and a sub did half the work).  I get $0.00 using =Sum([SubAmount]).   Then... when i try to bring the total amount back to my workorder page using =DSum("SubAmount","Subcontractorlaborf","purchaseorderid=" & [PurchaseOrderID])... I get a #error.

Question2 - i dont seem to be able to delete or change an option if i made an incorrect choice on these forms. (your forms are the materials forms).  Thanks for  your help... i am enjoying the seminar.

---

Reply from Alex Hedley:

Is the name of the field correct?

2. what happens when you try and delete, anything show in the status bar?