Form used for Calculations

[kidego32]

Hi all,

I want to create a form that will be used strictly for calculations. There will be two text input fields.

The calculations will be based on data that is stored in the database in various tables. For example:

User selects a category, a multiplier factor, and a finishing code.

The calculated field should then get the underlying data along with the user entered values in the two text fields and do the calculation.

Can this be done?


Thanks.

 

[Calvin]

Looks straight forward enough, so what is your problem?

 

[jfgambit]

Yes, can you give us some examples of the data in the files and what you want as the outcome?

You can add code to a command button or on the after update event of a field to run the calculations.