Update Wend Next sr End Sub '' Update all the fields, indexes, etc. '' This is a parameterless subroutine so that it can be used interactively.
newvalue An expression that determines the value to be inserted into a particular field in the updated records.
But there is error message saying 'Object doesn't support this property or method " Any idea why????
Note: Applications is the name of table, this table has 4 fields Application ID, Application, Owner, Responsible The New Owner is the name of the textbox that I have created for the user to enter the new Owner.
If that is the case, on the properties for the TAX field in the gotfocus area put the following in the code for the form: Private Sub tax_Got Focus() tax. Value * 0.02 End Sub If you make the properties for the tax field locked (again in the field properties for TAX and change the setting for LOCKED from no to yes) you will ensure that you don't put any data in that field which can sometimes happen when you press the TAB key doing fast input.
--Beat so in your table you have a field called GROSS and a field called TAX correct?