Default Values in Tables

[BobD]

I am trying to create a default value for a field in a
table based on the first 8 digits of a control(ProjectNo)
in a form (frmProjectDetails). The expression I use is
=Left([Forms]![frmProjectDetails]![ProjectNo],8) - when I
try to save the table design it tells me the field cannot
be found. What am I doing wrong?

 

[Ken Snell]

Default Values in a table cannot use external references - to form controls
or to other fields. They must be actual text or numeric values in their own
right.