default value for field

[De Lon Fox]

I am creating a table with the following fields: student number, class,
teacher, teacher evalution and grade level. The "class" field has a look-up
table directed to [class code].code. This look-up table is a three
character field.

I want to define the default value for the "grade level" field as the middle
character from the "class" field

Example for what I want
class grade level
A61 6
S83 8

What command goes in the default value for the "grade level" field.

 

[Allan Murphy]

In the After Update event of your class field put the following

me!grade_level = mid(class_field,2,1)

I am not too sure if class is a reserved word, also try use a single word
for your field as you will encounter coding problems using more than one
word.