I'm having a couple different issues. A little background on the db: I am IT/Dispatch Manager a a small AC company and I have made a db to streamline their dispatch system, particularly the part where I need to debrief with the tech and gather information. I wanted to have a button on my form that pulls up a sub-form where I could select any of the 26 parts available a technician could recommend. So the sub-form has two rows of 13 Yes/No boxes, each Yes/No box has 2 text fields next to it representing the regular price(field is called RPrice) for the part and the price with a service agreement(field called SAPrice).
When you click yes on the box I want it to auto populate with the default values for RPrice and SAprice, but if necessary the prices should be able to be changed if the tech quoted somthing other than the default values. I have gotten this far just fine.
My problem is that I want to get the total (both RPrice and SAPrice of all of the parts selected and I want that to transfer over to a field on the main form(FrmDispatch.RecPartsTotal). I also want to be able to recall what parts were selected and what price the tech left. I am having difficulty just getting these prices to add up on the FrmParts sub-form. It seems it just wants to list the numbers one after another like I am adding text to a sentence. How am I supposed to be abled to get the SUM of these fields?
I also wonder how my tables should be set up for this. Should I be keeping a second table that links with the primary key(DispatchID) that has a field for all 26 parts and a field for the Rprice and SAPrice of each part selected? Ultimately (and I seem to have this down pretty well already), I want the program to auto generate the notes with the parts and both prices for however many parts the tech discussed with the customer. So when the notes are generating it would look something like, “Coil cleaning Reg. “ & RPRice1 & “ with SA “ & SAPrice1
Let me know if I have been too vague or if more info is needed. Thank You.
-Paul