I have a Calculations form which runs a bunch of calculations on User input of a Project name.

I would like a record to be created in the Calculations form each time a set of criteria is met in the Project itself (i.e. if I enter the finished length of the project, create a new Calculation record for this project and run all the calculation statements). It would also be nice if the Calculation form would update if the Project form updated and that two of the same calculation form couldn't be created for the same project.

Right now I can get the Project Form to add a new record in the Calculation form with the right Project name, but it doesn't calculate any of the fields after that record is added.

How do I accomplish this?

thanks so much in advance.