Sorry I wasn't more clear. Yes, Amount is the name of the field in your table that you wish to add up. LaborTableName is the name of the table that holds the prices. The last part is the criteria of what you are summing. You said that your subform was linked to the main form by the Job Number, so if I'm understanding what you wrote correctly the Criteria should read "JobNumber = " & [JobNumber]. JobNumber should be the name that you called the field. You don't have to refer back and forth between forms to accomplish what you are trying to do. It sounds like you want the total on your Main Form. If you put what I have said into your control (textbox), it should work fine for you.