Search results

thanks, that helps. but where do i input the validation syntax to prompt this message before a new record is shown?

Hi, I have a form with a subform that's a datasheet. I have one field in the parent form that equals a number (called "transactionAmount"). I have a column of numbers in the sub form data sheet. I have been able to create a new field (called "lineItemTotal") placed in the parent form footer...