I'm trying to get a field to calculate based on other fields in a record.
For example:
if cboCName1 = "a" then
txtamt1 = 0.15 * txtpol1
endif
This code seems to work but it always calculates bases on the first record in the database rather than the current record. How can I get it to update based on the active record, and for that record only (i.e. not override every record with the current one)?
Thanks!