I have two forms 1st Form displays a payment schedule which has a column with field Funding Amount and in the footer Total Project Amount.
2nd Form displays a invoice schedule which has a column with field invoiced amount and in the footer total invoiced.
Is it possible to check if both footer total are a match ? If I add in a text box in form 1 =IIf([TotalProjectAmount]=[Forms]![Form2]![TotalInvoiced],"Matched","Not Matched") ?
I am getting #Name? error... Is there is way to check, need guidance.
Thanks
Taruna
2nd Form displays a invoice schedule which has a column with field invoiced amount and in the footer total invoiced.
Is it possible to check if both footer total are a match ? If I add in a text box in form 1 =IIf([TotalProjectAmount]=[Forms]![Form2]![TotalInvoiced],"Matched","Not Matched") ?
I am getting #Name? error... Is there is way to check, need guidance.
Thanks
Taruna