I have been trying to no avail to create a calculated field on a form
I have used the expression builder, I have typed in code manually, I have
tried using full table and field name syntax all without success.

In the control source I have
=[transactions]![amount] * 2
The table and field names are correct ( they appear in the expression
builder) and the amount field is a number data type.
All this produces is #name? in the form field
Every book and website I have consuled tells me that should work.
I am getting incredibly fed up with this pathetic useless software
can someone please tell me why this will not work.
Thanks in advance

Is the "amount" field from the "transactions" table in the form's
RecordSource query? If not, the calculated field will not work -- you must
use the DLookup function instead. See Help for info about it.

Many of us will disagree quite strongly with your assessment of ACCESS's
usefulness.

--

Ken Snell
<MS ACCESS MVP>


"Stahlhelm" <qrty (AT) froot (DOT) com.jp> wrote