Access 03: paste calculated result from a form into a table?

[Wizdar]

I’ve created a form that calculates entries from two fields, as in

=[Field 2]-[Field 1]

The problem is, although the results of the calculation are displayed in the form, they don’t get pasted into the table (Field 3).

I’m sure I’ve missed something simple, but can’t figure out what it is.

 

[ETID]

on some event in the form (right click and look at properties)...for a field of your choice "on lost focus" event for field 2 perhaps,

from the code builder for that event...

type...

me.Field 3=me.Field 2-me.Field 1

where "me." is the microsoft default declaration for the active form.

Each time the click or tabs out of field 2, it will calculate field 3...you will probably want to use some other event to trigger this action.

 

[ETID]

Ooops ..fumbled my words

Each time the user clicks or tabs out...