Blank form woes

  • Thread starter Thread starter dindigul
  • Start date Start date
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
 
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).
 
Back
Top