Blank form woes

D

dindigul

I wanted to create a calculated field on a blank form. However when I used
the expression builder, obviously it created the expression
=[table1]![expenses]*.15, but it did not work. Later I inserted a field from
the table, then typed [expenses]*.15 in a text box and it worked. My
question is when there is no reference on which table the form is based,
what's wrong in the above expression where table reference appears? Moreover
after I run the form, and again go back to design view, i see the argument
changed to =Table1!expenses*0.15. could anyone explain? Thanks
 
K

Ken Snell \(MVP\)

In order for you to use a field in a calculated expression on a form, that
field must be included in the query that is being used as the form's
RecordSource.

I speculate that the field Table1.Expenses did not exist in the RecordSource
in your first try; but did in your second try.

Also, although the Expression Builder uses the ! operator between a table
name and a field name, the proper operator to use is a . (dot or period).
 
Top