Sure, use an if/then statement in an AfterUpdate on the box that changes the type

Or you can use an IIF Function but nested IIF can get complicated

Form Footer Totals also

Hello All,
I added this formula in Field DocumentType under AfterUpdate
=IIf([DocumentType]="JPP",Sum([MemberShare])) and also under Total Share.
It totals for each member however, I want it display all members shares for the JPP Document Type and their shares but at end sub total for Member Shares.

Make an event out of that, don't just put it in there. If you click the ... to the right you can pick code builder and put it in there. But it looks like you have it in the wrong spot too. Are you using a combo box or anything to select when an item is JPP or another? If not, you'll want to put it in the on current event of the form itself. Can make it like this, you could put all the options into it even by added more elseifs

If DocumentType="JPP" Then
Text178 = SUM([MemberShare])
Elseif DocumentType="JPA1" Then
Text178 = 'insert other calculation here
End If

Hi Adam,
I am not using combo box, data is pulled from query.  As per your If then statement I understand that if DocumentType is JPP or JPA then perform this calculation. What happens when DocumentType both JPP and JPA1 options are available for one project  In the Form where do I place the subtotal for JPP and JPA1 ? Just letting you know One project  can have both document types and one is contract second is extended contract. So once you select the Project no it display all contracts and share and funding..

I must have misunderstand what you're trying to do. If you want to add all of them (JPP AND JPA1) then it should just be a sum of the fields in the query. Shouldn't need to do anything other than the SUM like you were.

If you want to list all of the members in the report, that can be done with the group and sorting settings. You could try and see if THIS explains it for you otherwise it's covered in expert 12.