Computed field on data entry

[Bill Burton]

I need to have a computer field automatically update when
data is entered into a form. I will be combined elements
from two entered fields to create a third field. How do I
do this?

 

[Tim Ferguson]

I will be combined elements
from two entered fields to create a third field. How do I
do this?

You don't. This is a job for a SELECT query[1], which will be always up to
date and faster, will eliminate your maintenance headaches and generally
put you on the side of the angels.



[1](or perhaps a calculation in a textbox on a form or report, but getting
the server to do it is usually better)


HTH


Tim F

 

[Steve Schapel]

Bill,

Put an unbound textbox on the form, with its controlsource property
set to something like this...
=<the bit from the first field> & <the bit from the other field>
If you mean you have a field for the combined data in your table which
the form control is bound to, it is very likely that this is not a
good idea.

- Steve Schapel, Microsoft Access MVP