Re: Use record number of subform to assign letters

Thank you!!! It is in single form view so i used something similar to what 
you suggested for that, but as i needed it to write onto the underlying
table 
and query i used it as a macro, it works ok but the only problem is it
only 
corrects the record that it currently shows. The letters usually go no 
further than D or E so it is no big problem. It is useful to know that i
can 
use the expression [CurrentRecord] and Chr(blah blah) and i may be able to

put them to use in other places. Thanks again for ur help.