forcing an update....

[Brad Pears]

I have a form that is based on a table. Not all the fields in the table are
on the form as some are control fields..

In code I am setting on eof the fields that is not on the form to a value. I
want to perform some action based on this new value right away but the
record has not been saved yet and hence my action does not get the correct
results.

How can I force the record to be updated immediately after I set a field
value in a table?

Thanks,

Brad