Formula on form to update table?

[burrelly]

I have a table 1 and it has a number in it. Table 2 that has 20 numbers in it.

I have a form that has a box with the number from table 1. There is a second box that has the total of all the numbers in table 2.

I then have a third box that calculates box 1 - box 2.

The result that is in box 3 I want to enter into table 3.

Any Ideas?

 

[ACMAIN_CHM]

maybe you can put the code into the button click event.

currentproject.connection.execute "insert into table2(column1) values " & text1.value & "+" & text2.value

 

[boblarson]

You should NOT (in 99.9% of the cases) be storing calculated data in a table. If you have the two operands then you can calculate it when you need it. This is for data integrity and normalization principles.

There are RARE occasions when you might store a calculated value. But, it isn't likely that yours is one of them.