Updating table with an unbound form field

[mosto]

Hi, I'm sure this is very simple, but I can't figure it out. I'm creating a database to generate weight dockets. The table 'Dockets' contains the following fields 'Gross', 'Tare'. I've created an AutoForm from the table, but to get the 'Nett' field on the form to calculate, I've unbound it from the 'Nett' field in the table and entered the expression =[Gross]-[Tare] as the Control Source, but this does not update the table with the correct figure in 'Nett', I'm assuming because it's unbound.



So my question is how do I get the 'Nett' field in the table 'Dockets' to update when the Gross and Tare is entered in the corresponding Form?

Thank in advance.

[davegri]

In your form, assuming the name of the Nett textbox is txtNett, add this code to the form's current event:

txtNett = Gross - Tare

Many developers avoid keeping calculated fields in tables. The value can be easily calculated in a query as needed.

[mosto]

Much appreciated. Sorry, fairly new to using access from a development point of view, learning as I go. I've gone down the query route you mentioned, makes much more sense.