Computed field on data entry

  • Thread starter Thread starter Bill Burton
  • Start date Start date
B

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?
 
I will be combined elements
from two entered fields to create a third field. How do I
do this?
Click to expand...

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
 
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
 
Back
Top