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