How to set a value in a field automatically in Access 2010 table

[SalvadorD]

I have table called Balance with the following fields:
year date,
CAsset double,
CLiabilities Double,
Difference Double

I need to set a value in Difference field automatically by using this operation: CAsset - CLiabilities

 

[SalvadorD]

But also disable the field difference becasue it will be fillied automatically

 

[randy700]

First, you should not use "year" as a field name, because it's a reserved word. CYear would work.

Second, the value you're suggesting for the Difference field is a calculated value. Standard practice is to avoid storing calculated values in tables. They are better obtained by using a query.

SELECT CAsset - CLiabilities As Difference
FROM myTable

Randy