auto populate data on field based on data entered in first field

[edwardcga]

Hi:
I am a newbie in access programming and need help in the following situation:
I have a main / subform for entering donor contribution. Main form OFFERING, SUBFORM OFFERING_DETAIL.
In the subform, I have the following columns:

1st column
ENVNO (Envelope number assigned for :
Cash M01 TO M99
I will enter "M01" for first envelope for CASH envelope, "M02" for next etc.
SAME applied for Cheque payment which will be from Q01 TO Q99 and VISA PAYMENT which will be V01 TO V99

2nd column
PAYT_TYPE (LENGTH = 1, "C" for cash, "Q" for cheque, "V" for VISA)
This is the field that I want to auto populate
If first digit of ENVNO is "M", then assign code "C", if "Q", then assign code "Q", if "V" then "V"

3rd column
AMOUNT

enter amount of contribution



Your help and advice in the above will be much appreciated.

EW

[RuralGuy]

If the first character of the field depends on another field, then you don't need the first character. *hint*