Hi Paul, > How are automatic calculations of fields in a form accomplished? I have > for example a 'rate-per-hour' (in dollars) type of field that I would like > to set > to a fixed value (and changeable easily when needed) and appear in the > record, then another field which is 'time billed' (in hours or parts of), > then a > 'total cost' field. I would like the 'total cost' field to show the total > cost based > on the values of the other two fields automatically.
You'd need macros for this. If this doesn't scare you, we could go into details ... In general, you'd need to listen for changes in the fields which are used in the calculation, do your calculation, and update the target field. Not too difficult in general, but some lines of code ... Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
