Default Values in Tables

  • Thread starter Thread starter BobD
  • Start date Start date
B

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