First off I will explain the design of my form. I have a sub form to show the records for a each client. In each record is a cost field which is inputed by the user. In the form footer of the sub-form is a text box set to invisible. This box calculates the total for that customer using the formula "=Sum([Amount Paid])".
On the main form, there is another textbox with references the calculated field on the subform so that I can show the total on the main form (control source=[tblInvoice Subform].Form![total]).
What I want to do is change the properties of the box on the main form when the value is more than 300. I don't know which event to place the code in and I need to check the value when each record of the main form is displayed and when the calculated field is updated. (i.e if the user inputs another invoice and the total goes over 300 the properties change)
Thanks for any help.
On the main form, there is another textbox with references the calculated field on the subform so that I can show the total on the main form (control source=[tblInvoice Subform].Form![total]).
What I want to do is change the properties of the box on the main form when the value is more than 300. I don't know which event to place the code in and I need to check the value when each record of the main form is displayed and when the calculated field is updated. (i.e if the user inputs another invoice and the total goes over 300 the properties change)
Thanks for any help.
