Posting calculated values from a form field to a table

[Stuart Green]

I have a form that users enter car registration numbers on. As well as storing the number on theunderlying table, I want to store the first 3 digits of this number within the table in another field. I have tried creating an unbound field on the form to calculate the first 3 using left$([regnumber],3) which works OK but am having difficulties working out how to save this value in the table. (I will eventually use this 3 digit value to be the basis of a relationship with another form). I am sure I am missing something basic here, patience please if it is obvious!

 

[DJN]

In the After Update event procedure for regnumber, add

[FieldName] = Left([regnumber], 3)

David

 

[Stuart Green]

Many thanks (he says with embarassed expression), it was that easy!